Macro to C&P from a saved file in a seperate folder

[CRMTHB]

Hi,

Each month we run a report with multiple tabs and we save this down. I then need to copy and paste specific tabs from that report, into a calculation sheet. On this calc sheet, there are separate sheet which hold formulas which run off the report tabs. The report tabs are in a set order but not the same order as the original report tab

I want a quick way to update the report tabs on the calc sheet, every time we rerun the report - which we run a dozen times before it's finalised

I was thinking of a macro which ran from my calc sheet. It would either:
- look at the name of the tab it was currently on (say, "Bananas"), then go to folder X, open up file Y and copy the "Bananas" tab from there, and paste it over the "Bananas" tab of the calc sheet
or
- it would do the above for a specified list of tabs (say, "Bananas", "Oranges", "Apples" etc)


I hope that makes sense, if doesn't let me know. Or, if there is a simpler solution to this, I'd be happy to hear it

Thanks