Need 1 worksheet to add totals from multiple worksheets in the same file.

Create a summary sheet and use a 3D SUM formula to pull totals from the same cell across sheets (e.g., summing A1 from Sheet1 through Sheet5). It’s the simplest way to keep a running total.