On the LinkedSummary worksheet, in cell A4, create a linked consolidation using cells A4:D15 from each of the school worksheets. Be sure and select Top Row, Left Column, and Create links to source data in the Consolidate dialog box. Then on the LinkedSummary worksheet, change the column width of column A to 13, hide column B, and change the column width of Columns C:E to 12.
Solved by K. L. in 19 mins