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.

  • 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.