I need to copy data from each workbook which will be in the same folder. Each workbook will have a different name. Each workbook will have a sheet named Volumes and a sheet named C&A
I need to copy both of these sheets from each of the workbooks into a my active workbook and name the sheets based on the name in cell C3. [i.e. If C3 = London, name Sheets London Volumes and London C&A]
In the Active workbook will be a sheet named 'Master'. I need to collate the numbers from each sheet into the respective cell in the Master Sheet. [i.e. starting at cell D8] (add the total of all cells D8 and enter total in cell D8 in 'Master' Sheet)
I have attached a sample file but have only shown 2 Extra sheets and only shown data in D and E, group A and B.