You can create formula in excel that get data from multiple worksheets without having to specifically reference each sheet by using 3D references.
In the example above all the values in C3 will be added together from each sheet from Holiday1 to Holiday3. No matter what the sheets are called, if they sit between Holiday1 and Holiday3 their value in C3 will add in to the total we see here. Obviously, you need to be a little bit careful with this one, and not move sheets around, or let other people move sheets around or you will get unexpected results.
You can type the formula in with the colon in-between the sheet names, or just type “=sum(” select the cell in the first sheet you want to include, and then hold down the shift key and select the last sheet you want to include in your formula.
Note: This only works if the data to add is in the same cell in every sheet.