Yeah, sorry, it's been asked 1000 times, but My VBA knowledge is very limited and those solutions aren't quite what I need.
I have to gather the data from many workbooks to one "master" workbook
First of all all the workbooks have only 1 populated sheet (sheet1) and they all have the same headers, so all the data should fit.
So what I need is:
Activate "Book1, sheet 1", copy the contents of columns A:N (without the header because it's the same as in the master sheet) - however long they are, there can be 200-600 rows.
then activate "master workbook, sheet 1" find the first blank row in column A, then paste special as "XML Spreadsheet" (at least that's what I have to select manually for the data to look the same)
Hopefully I explained properly. Thanks.