Summarizing data from multiple individual sheets to one summary sheet in same workbook

[gerihayes@comcast.ne]

Greetings,

Would appreciate any help. I am reviewing documentation for area school reimbursement requests. There are 41 schools to review. Each can be indentified by school division number and name. I would like to have a separate sheet for the review of each school division and then a summary sheet for all school division. I would like the information I enter into each indvidual sheet to automatically fill the summary sheet based on school division number. For example Wythe County is school divsion # 97. I would like all info I enter under sheet 97 be automatically copied onto the summary tab next to the corresponding school division number. I am attaching the file with a summary tab and a few of the school division tabs.

Thanks for any help anyone can provide.