Combine 30+ single sheet workbooks

[nightracer]

Hi

As per the title, I have multiple single sheet workbooks, and need to compile the data from each into one single sheet, taking the data in columns A-V.
All of the workbooks have the same column headers in row 1 and are in a single folder.

The number of rows can vary from 150 to 500+, so overall I am looking at 12,000+ rows.

Ideally it would happen in order, so pick all the data from Book1, then Book2 below that, then Book3 and so on.

The number of workbooks generated that need compiling can vary from 25 to 360.

Is this possible via either a macro or an add-in menu solution?

Any pointers appreciated.

 

[nightracer]

Thanks, with that change it still cycles through the workbooks, but then just highlights rows 2 & 3 only in the combined book without bringing anything in.

 

[MARK858]

And is there data in column A in the source workbooks?

If there is put a breakpoint on the line below then activate the source workbook (if not activated already), where are the marching ants from the copy?

ThisWorkbook.Worksheets(1).Activate

 

[nightracer]

Apologies, I have no idea what that means.

All of the source workbooks have data in column A and that column has the same number of rows completed as all other columns.
In the first source book there are 255 rows, in the next 131, the 229 and 176.

 

[MARK858]

To set a breakpoint...
Click in the left margin next to the code line, you should have a circle appear in the margin and the line should be highlighted (reddish-brown in my case) then run the code.

The code line will turn yellow and the code will stop.

Look at the source sheet and check what area is selected for copying (the moving dotted lines).

 

[nightracer]

When I click in the left margin it highlights in brown/red and doesn't highlight anything in the source sheet.

It's all way beyond my know-how, apologies.

I thank you for all your help, not to worry, I'll look for a another way to do it.

Thanks again.