Some call it a 3D reference or a spearing formula. If your Excel worksheets are all perfectly lined up, you can use this formula to sum across worksheets in Excel.
But if your worksheets are not in the same sequence, then you can use TOCOL, SORT, UNIQUE, and SUMIFS to solve the problem.

This video answers these search terms:
how ot easy sum tabs in excel
how sum across multiple sheets in excel
how to calculate sum from other tabs in excel
how to do sum across two worksheets in excel
how to do sum of cells in multiple sheet in excel
how to get multi excel sheets to sum
how to get sum from multiple sheets in excel
how to sum across excel tabs
how to sum an entire workbook in excel
how to sum cells from different excel sheets
how to sum cells from different sheets excel
how to sum cells inexcel from multiple sheets
how to sum columns in excel from multiple tabs
how to sum different tabs in excel
how to sum forumla across multiple sheets in excel
how to sum from multiple excel sheets
how to sum from multiple sheets in excel
how to sum in excel across multiple sheets
how to sum in excel across tabs
how to sum in excel on different tabs
how to sum multiple pages in excel
how to sum multiple sheets excel
how to sum multiple tabs excel
how to sum multiple worksheets in excel
how to sum several sheets in excel
how to sum tabs in excel
how to summarize excel sheets on one
how to use sum function with 3d reference excel