Summary Worksheet - Join Several Workbooks Into One?

Im currently working on making a workbook as a summary/join of several workbooks. All cells are formatted in the same way, and only Row 1 is the same in all workbooks.

How to combine several excel files into one file?

My issue is that when i run this macro, the rows are overwritten for every workbook runned through.

I end up with only the contents of the last copied workbook.

I guess my EndRow is wrong, or the copy function, since the offset is not set properly.

Code:
Sub ExtractData()Dim basebook As Workbook
Dim mybook As Workbook
Dim FNames As String
Dim MyPath As String
Dim SaveDriveDir As String
Dim Cnum As Integer

[code].....