I would like to consolidate multiple spreadsheets within a specific folder on
a server to a single sheet on a spreadsheet located on my (or someone else's)
PC. The spreadsheets on the server are all in the same format, in that they
have identical columns as does the consolidation spreadsheet held locally.
Ideally I'd like the code to write to the next available line of the
consolidation spreadsheet. Thus.

Server

Spreadsheet1 - 3 rows of data
Spreadsheet2 - 4 rows of data
Spreadsheet3 - 6 rows of data
etc
etc

Local PC

Consolidation Spreadsheet - First row includes Headers.

So the Consolidation spreadsheet would take data from Spreadsheet1 and place
it on row 2,3,4 then place the data from Spreadsheet2 on row 5,6,7,8 etc.

Many thanks in advance for any help you can provide.