Hello!
So, this is my situation - I have developed an excel tool, which makes a lot of useful calculations for me. The calculations come from 10 other sheets, which are in the same file.
So, in general, I have an excel file with about 20 sheets - 10 make the calculations and 10 serve as input data.

My issue is, that every month I get new input data (10 sheets) and I need a way to integrate them to the tool and to make it work.

What I do now:
1. I take every sheet of the 10 sheets for "input data" and I rename it manually, putting "old_" in front.
2. Excel automatically changes the formulas in a way to reference this "old_" name. (This is actually my problem!)
3. I insert the 10 sheets with the new data.
4. I press about 10 times "Replace" and I replace the formulas with "old_" to the new sheet.
5. It takes me a lot of time... And I do not like it

Any ideas for process improvement? I understand also macros, so you can give an idea there. I can write a macro, which does exactly the same process for me, (the work is actually 80% macro recorder and 5% deleting useless code actually ) but there should be a more clever way in Excel to do it... Really, something like turning off automatical references or something...

Any ideas are welcomed!

Thank you!