Is it possible to pull information from multiple tabs and make it customizable without altering formulas?

Apologies for the confusing title, but I'm not sure how else to word it.

I work in a sales-focused role, recently at my job we have been required to send out sales recaps to higher ups. We need to calculate how many sales points we make daily along with calculating goals. I am using the web version of excel since I have to share this across a team.

My current set up is as follows:

- Each employee gets their own tab with a list of products we sell + how many points they are. Throughout the day they enter in what they did and it automatically calculated the points they earned.

- I have another tab called "calculator". This combines all of the totals across the tabs into one chart. ex: =sum('employee1!' A1, 'employee2!' A1) and so on.

- the final tab pulls the important information from the calculator tab and into the format that they want it in.

I've been asked to share this spreadsheet with other locations, but many of my co-workers are unaware of how to set up a spreadsheet like this. I want to make it as user-friendly as possible before sharing it. I want to be able to add/ delete "employee" tabs as needed without having to change formulas on the main "calculator" tab. Is there any way to set up the =sum() function to change based on the number of tabs automatically?