I have a spreadsheet with 30 tabs. Each tab has the exact same format (income statement). I need to add all of the tabs togeather on summary sheet. There has to be an easier way then mannually selecting each cell.
If you will only be using SUM, and the number of sheets changes, then insert two new worksheets, one labeled First, then other Last. Put all the other sheets that you want added between them, then modify the given formula to:
This makes it easier to "What If" scenarios by moving sheets outside of First or Last.