Copy data from workbooks to a tab of the same name

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 which are all contained in another folder.

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 the 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 (Fruit, Meat, Veg, Bread) in the Master.xlsm workbook


Any help would be awesome.

Thanks

Bill

Possibly...

Please Login or Register  to view this content.

Thank you dangelor!!

That is the code I am after!

I am going to adapt it slightly but that is what I'm looking to do.

Have a great weekend!!!

Top banana!!

Glad it worked for you!