Option Explicit
Sub Zusammenfassen()
Dim ii As Integer, lngZ As Long, lngQ As Long
Worksheets.Add before:=Worksheets(1)
For ii = 2 To Worksheets.Count
With Worksheets(ii)
lngQ = .Cells(Rows.Count, 1).End(xlUp).Row
Range(.Rows(1 - (ii > 2)), .Rows(lngQ)).Copy Cells(lngZ + 1, 1)
lngZ = lngZ + lngQ + (ii > 2)
End With
Next ii
End Sub
Rückmeldung wäre nett! - Grüße von Erich aus Kamp-Lintfort