I have got several excel sheets, every single one of them containing a table for user information and one last sheet which contain the sum of all the previous tables. Since my table is very big, is there a way to create automatically a formula which will sum all the tables of user sheets to the table of sum sheet. The tables are exact in the same position.

`A1 = user1!A1 + user2!A1 + user3!A1 + ...+ userN!A1`

I'm looking for a better way to select multiple sheets. Additionally, when I add new worksheets for additional users, I want the new worksheets to be included in the calculation without modifieng all formulas manually.

How can I perform what I want?