Private Sub Worksheet_Activate()
Dim lig&, w As Worksheet, P As Range, h&
lig = 2
Application.ScreenUpdating = False
Rows(lig & ":" & Rows.Count).Delete 'RAZ
For Each w In Worksheets
If w.Name <> Me.Name Then
Set P = w.[A1].CurrentRegion.EntireRow
h = P.Rows.Count - 1
If h Then
P.Rows(2).Resize(h).Copy Cells(lig, 1) 'copier-coller
lig = lig + h
End If
End If
Next
End Sub