Copy data from workbooks to a tab of the same name

[Bill Morris]

Hi

I have a workbook (Master.xlsm) which is a summary of other workbooks.

A page in the Master workbook has a list of the names of the other workbooks.

Eg

• Fruit.xls
• Meat.xls
• Veg.xls
• Bread.xls

What I want to is create a macro which will:

• go down the list and create and create a tab in Master.xlsm for each item (Fruit, Meat, Veg, Bread)
• then go into a folder where these workbooks reside and copy a range (eg A5:F200) from the 'Data' tab in each of these workbooks
• Paste these values into the corresponding tab in the Master.xlsm workbook

Any help would be awesome.

Thanks

Bill