A three-dimensional Excel reference points to the same cell or range across multiple worksheets. It can simplify a summary when monthly sheets share a consistent structure, such as a subtotal stored in the same position on every tab.

Summarize the Same Excel Position Across Several Sheets

The reference includes a span of worksheet names as well as the cell coordinates. Consistent layout and data meaning are therefore essential: a formula cannot tell whether one sheet uses that position for a different measure. Inspect the included sheets and their shared structure before using the reference for a grand total or another cross-sheet aggregation.