Sub Macro1()
Dim Compteur As Integer, Der_Ligne As Long
ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count).Range('A4:C65536').ClearContents
For Compteur = 1 To ActiveWorkbook.Sheets.Count - 1
Der_Ligne = ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count).Range('A65536').End(xlUp).Offset(1, 0).Row
If Der_Ligne < 4 Then Der_Ligne = 4
ActiveWorkbook.Sheets(Compteur).Columns('A:A').SpecialCells(xlCellTypeConstants, 1).EntireRow.Copy _
Destination:=ActiveWorkbook.Sheets(ActiveWorkbook.Sheets.Count).Range('A' & Der_Ligne)
Next Compteur
End Sub