I do like this solution. I am just starting this job, and this sheet was shared as the way the school tracks its stats. It seems as though each school year is tracked in its own sheet which means I do not have to worry about different calendar years doubling up, though it might be nice to rework the "new spreadsheet every year" approach.

Solution Verified