Summarizing Data From Multiple Worksheets

Copper Contributor
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 =('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?
2 Replies


Use the INDIRECT function: