Summary page to read new tabs

Hi Excel Gurus, I require your help.

I need to create an excel template for an organisation that makes revenue off hiring out its venues to external hirers who wish to put events on.

I have my hire rates and labour rates in the ‘background’ that feeds into my ‘event template’ which is similar to a profit and loss statement for that individual event, and then a summary page that feeds of these multiple event P&L tabs to give a high-level view. I know how to link everything via formulas easy enough, my issue is I wish to give autonomy to the users and allow them to simply copy and paste my P&L template to create as many events as they wish, yet still have the summary page pick these new tabs up, without having to manually enter in the new tabs into the formulas. What is the best way to go about this?