I have been trying to develop a couple of functions that use the INDIRECT function.

I have been passing cells to indirect to retrieve multiple sheets, like:

Sheet Names
Jan | Feb | Mar | Apr | May etc....

I want to sum the cell A208 across three sheets ex. quarterly total

And I want to do it dynamically so user can choose "dropdown" which quarter total they want to view.

So in Sheet "Qtr Totals" I would have A1 = Jan:Mar or Apr:Jun

Then function would be

=SUM(INDIRECT(A1&"!A208"))

However, function gives #VALUE or #REF.

Any insight greatly appreciated.