Fandt selv svaret andetsteds.
Sådan her:
Public Sub CopyFørsteRække()
'Ret "Ark1" til navnet på det ark du vil have dataerne på
X = 1
Antal = Worksheets.Count
For Each Ws In Worksheets
If Ws.Name <> "Ark1" Then
Worksheets(Ws.Name).Rows("1:1").Copy
Sheets("Ark1").Paste Destination:=Worksheets("Ark1").Cells(X, 1)
X = X + 1
End If
Next
Worksheets("Ark1").Select
Range("A2").Select
Application.CutCopyMode = False
Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom
End Sub
Perfekt