Forum Discussion
Solved
Selecting one cell from multiple sheets for summary page
Hi everyone, I'm sure there is an easy answer to this, but I just can't seem to find this answer through search. I have about 50+ sheets that are all the same format. I want to create a sum...
With the sheet names in A2, A3 etc., enter the following formula in B2, then fill down:
=INDIRECT("'"&A2&"'!C31")
With the sheet names in A2, A3 etc., enter the following formula in B2, then fill down:
=INDIRECT("'"&A2&"'!C31")
Rockstar! Thank you so much. Worked like a charm!