Sub Macro1()
For Each s In Sheets
If s.Name <> "Recap" Then
For i = 4 To s.Range("A65000").End(xlUp).Row
Sheets("Recap").Range("a4").Offset(k, 0) = s.Range("a" & i)
Sheets("Recap").Range("b4").Offset(k, 0) = s.Range("b" & i)
Sheets("Recap").Range("c4").Offset(k, 0) = s.Range("c" & i)
k = k + 1
Next i
End If
Next s
End Sub