Copying data from multiple workbooks to 1 master workbook

[chilli76]

Hi guys

Can anyone help with the following query I have?

I have around 41 workbooks to represent different football leagues which are all identical in layout. What I was wondering was, is it possible to copy/import data from a sheet in each workbook and populate a master list in another workbook?

I'm guessing that in itself it's not a problem for someone who knows what they are doing but a problem I can forsee is that as I need all the sheets data listed underneath each other then each copy/import data set needs it's own cells attributing. For example data from Premier league workbook will occupy rows 3 -12 and data from championship needs to occupy rows 13 - 24 and then data from League One needs to occupy rows 25 - 36 and so on.

I've attached the intended master list workbook and the premier league workbook.

All League Master Sheet.xlsx
Premier League.xlsx

Any help appreciated

Cheers

[patel45]

http://www.rondebruin.nl/win/s3/win008.htm

[chilli76]

Thanks for that, I will give it a try