Dim i As Long
Dim tabloNomsFeuilles() As String
Application.ScreenUpdating = False
Sheets("Recap").[A1].CurrentRegion.Offset(1, 0).Clear
For i = 1 To ActiveWorkbook.Sheets.Count
ReDim tabloNomsFeuilles(1 To i)
tabloNomsFeuilles(i) = Sheets(i).Name
If Sheets(i).Name <> "Recap" Then
Sheets(i).[A1].CurrentRegion.Offset(1, 0).Copy Sheets("Recap").[A65000].End(xlUp).Offset(1, 0)
End If
Next i
Application.ScreenUpdating = True