Multiple Worksheets - In desperate need of help!

[Exceluser20007]

Greetings, All!
I am new to this forum and will appreciate any advice/ help
I have a spreadsheet that consists of a few worksheets. The first couple of worksheets have data manually inputted in them. The last and final worksheet has cumulative data from all preceding worksheets. How can I add a few more worksheets and ensure that the formulas in the final worksheet will include data from the new tabs?

Thank you!

 

[SpillerBD]

If the formulas on the Summary Sheet are 3D formulas, you only have to insert the New Sheets between the first and last detail sheets.
If the Summary sheet is a Pivot Table based on Combined data through a Power Query, It depends on the Query.
If the summaries are based on Sum of the individual Tables or Worksheet ranges, you'll need to add similar segments to the existing formula.
...