Alternative to Indirect when linking to worksheets which change names

Hi Excel gurus

I am trying to find a non-volatile solution to the use of the Indirect function when linking to a worksheets. I have attached a workbook to show you what I am doing

- The work book is a Consolidated budget for a division that has 3 departments, department A, department B and department C. The division is preparing the annual budget for the year so project managers are meeting with clients and understanding their requirements for the coming year. for example a client may be planning to do 5 projects next year.
- The Project manager then enters the project name "Example 1" in the "Total Cost" worksheet in column D, selects the cell with the name in it and clicks on the macro "Create budget sheet" which copies the "budget template" and creates it for the project "Example 1"
- The project manager then completes the budget template for "Example 1" which holds all of the costs from each of the departments A, B and C for each project.
- These costs are then pulled into the department tabs "A", "B", "C" by using the formula Indirect and summarised in the "Total Cost" tab.

There are several project managers all feeding into this sheets and 50+ clients resulting in 250+ project names (and therefore that many project sheets being created over the course of several weeks). I have only shown 3 rows in the attached.

I have therefore used the Indirect formula to link to the new worksheets as and when they are created i.e. the formula is already set up in the sheet for 200+ rows and when a sheet is created, the links are already there to the budget sheet.

This is causing performance issues because of the use of Indirect formulas in the A B and C tabs. I want this to be a self-serve process so the managers can dip in and out and not have to worry about things like turning auto-calc on and off as it is a shared work book

Is there an alternative to the Indirect formula that can link into worksheets where the worksheet name is not yet know but will be created by a user in the above way?

Thanks