Summarizing Data From Multiple Worksheets

Question

Spoiler (Highlight to read)This is probably a simple ask...I'm trying to summarize data from multiple worksheets using a formula. I know how to write the formula using the worksheets name&nbsp;=('2021'!$B$16). Instead of using the 'worksheets name' I'd like to fill that spot in the formula with the value of what appears in field A5. =('(a5)'!$B$16) I've tried multiple versions of this formula but keep getting error messages. Can anyone help?This is probably a simple ask...I'm trying to summarize data from multiple worksheets using a formula. I know how to write the formula using the worksheets name&nbsp;=('2021'!$B$16). Instead of using the 'worksheets name' I'd like to fill that spot in the formula with the value of what appears in field A5. =('(a5)'!$B$16) I've tried multiple versions of this formula but keep getting error messages. Can anyone help?

hansvogelaar · Answer

Ron_Sloane&nbsp;
Use the INDIRECT function:
=INDIRECT("'"&amp;A5&amp;"'!B16")

ron_sloane · Answer

HansVogelaar&nbsp;THANK YOU!!!

Forum Discussion

Summarizing Data From Multiple Worksheets

Share

Resources