I have a workbook with a variety of names ranges. I need the data to flow
into corresponding cells based on the result of a formula in a different
cell. Example:

A1 contains a validation drop-down of all the named ranges in the workbook.

Range A2:D12 results in the selection of the drop-down in A1. These named
ranges are from different workbooks. I've tried lookup functions, but they
will not accept a cell reference in place of a hard-coded name to lookup the
correct range of data.

I need the cell reference to insert into a formula as a named range.
A1=NamedRange

I end up getting the value in A1 returns in the formula as only the only
data. The value is not recognized as a named range.

I hope this makes sense.