Summary page from all tabs

[seanpcorbett1]

might not be the most effective way to do it, but I think it might be the simplest if I can get it to work? Currently I have sheets within a workbook with tabs labeled (1), (2), (3), etc. etc. Each tab is formatted the same. Then I want a summary page to draw from cells within each tab.

Simple formula would be ='(1)'!E13.

I've set up a column that has the the sequential numbers in the format as the reference ie. '(1)'!, '(2)'!, etc.

Is there a way to reference the cell containing the text on the summary page, to effectively pull the info from the cell on the referenced tab?

 

[Joe4]

Yes, you can use the INDIRECT function.
See: http://www.contextures.com/xlFunctions05.html

 

[seanpcorbett1]

Thank you! I'm an idiot... I've used it numbers of time but have been out of the excel game for a while.

 

[Joe4]

Thank you! I'm an idiot... I've used it numbers of time but have been out of the excel game for a while.

No worries! We have all been there.
Glad I was able to help!