toggling which worksheet a named range refers to
 

I have a "real data" worksheet (Table1) that is populated automatically using
Template Wizard with Data Tracking. I want to keep that data intact.

I have an identically structured worksheet (TestData) that I want to be able
to muck around with to test formulas.

I have a bunch of formulas in various other worksheets that use Names that
currently refer to ranges in TestData. I would like to be able to toggle
those names to refer to either Table1 or Test Data (same range in either
sheet).

I've tried 2 approaches that work:
- Using the INDIRECT function to construct References based on a worksheet
name typed into a cell
- Putting the 2 worksheets in separate workbooks (same sheet name in each)
and using Edit Links to switch between the two.

However, with both of these approaches, the Name does not show up in the
Name Box -- definitely an inconvenience!

Is there any way I can have my cake and eat it too? (i.e., be able to toggle
worksheet in reference AND have Name show up in Name Box)?

Thanks.

ps -- I'm a neophyte with VBA and macros. Solution requiring neither is
preferred, though I will venture forth if necessary!