Excel Links to Summary Page from Multiple Sheets

Hi,

I am trying to shorten the length of time in obtaining the information that I need. I have an Excel workbook with hundreds of sheets (Sheet1, Sheet2, etc). I need three numbers on each of these sheets to be pulled to a summary page. Is there a way to do so, without having to click on each sheet and manually link it to the summary page (it doesn't have to be linked anymore, just need the information)? I have included a sample workbook of what I am attempting to do with more information below.

Charge Number: Always located in Cells C:G11 (system automatically has the cells merged)
Funded Amount: Always located in Cells S:U11 (system automatically has the cells merged)
Total Cost: Located in Column T:U (merged cells) but the row number is different in each cell. It is on the row labeled "Total Direct Labor" in Column A:F. Is there a way to obtain the row number for each spreadsheet based on that phrase?

Thanks in advance!

Thanks so much for the help. Do you place the match function inside the indirect function? (Sorry for the silly question.)

That depends on what you are wanting to do.....I wasn't sure. If you want to return the numbers.....

Formula:

Please Login or Register  to view this content.

would get you the first figures referenced in Summary Sheet. How this works inside of INDIRECT.......I'll have to fiddle with that one. Give me a bit of time with it.

You are a genius!
Thank you! Thank you!

You're welcome. Glad it works. . . .and thanks for the feedback.