Simplify Your Summary Page Formulas

To create a workbook where the first page summarizes the rest of the workbook, make sure that your workbook has at least 4 sheets. Name the second sheet Start and the last sheet End. Hide these two sheets, which should left be blank. On the first sheet, the formula =SUM(Start:End!B2) will sum cell B2 on all other sheets in the workbook. Additional sheets inserted later will automatically be included in the summary.