On the LinkedSummary worksheet, you want to consolidate data and include the cell references from other worksheets that contribute to the consolidated data result. In cell A$4,$ create a linked consolidation using cell range A$4$:D$15$ from each of the school worksheets. Select Top Row, Left Column, and Create links to source data in the Consolidate dialog box.