Copying a workbook cells from another workbook

[ahs004]

Hi,

I work for a company that has 10 regions. Each region needs to complete monthly data in the format that i have provided.
I then need to amalgamate this into 1 spreadsheet. I have used links in the past but had alot of broken links so the data was not reliable from month to month.
I need to create links using VBA from local region spreadsheets to my main spreadsheet where will copy the data into specific fields.

I have 10 identical spreadsheets with 9 table of data in each spreadsheet.
Need to copy each table from workbook 1 to 10 into my main workbook.
I have named the ranges but could not wirte the code to do this. I did try and record it but it takes too long as i will have to do it individually.

Is there a code that i could use the copy it range at a time? also each month the file will be at a different location but all spreadsheets in one folder. if possible will need to select or type the location to the code prior to copying the links.

Hope i made it clear.

I have happy to post a sample if required.

Thank you