I have a large spreadsheet with each tab organized as a table, each table has
a dynamic named range.

My users want to access data from this main source by selecting a range name
from a list (cell with dropdown list). I have been able to get this to work
in one workbook by using INDIRECT to capture the range name and INDEX\MATCH
to bring in the actual cell contents.

When I try to do this with INDIRECT I get the REF# error. Is this something
that can be done?

Thanks in advance for any help or suggestions.
--
Scott S