Can be useful for a number of things
Using Excel's Sum Function on Multiple Tabs
One of the best features of Microsoft Excel is the ability to add values. While this is easy enough on a single worksheet, what if you want to add cells that appear on multiple worksheets?
We will show you a few ways to add cells to different sheets in Excel. You can add the values that appear in the same cell in your spreadsheets or different cells.
If you have several worksheets with identical layouts in your Excel workbook, you can easily add the same cell reference across multiple worksheets.