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

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.

Hi,

Is this the sort of thing you were after?

I hope this helps

are these formulas helpful? they assume that all worksheets are using the same template and the name of the worksheet is the division number

Yes, Exactly.... It helps very much. Thank you

Originally Posted by rcm

are these formulas helpful? they assume that all worksheets are using the same template and the name of the worksheet is the division number

Yes, they are extremely helpful.... Thank you very much!

You're welcome

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks

Originally Posted by ajryan88

Hi,

Is this the sort of thing you were after?

I hope this helps

Yes, This helps a great deal. Exactly what I need. Thank you!