How do I use the data in a named field to select a worksheet tab .

[Guest]

I need to use a named field to select a worksheet tab in another workbook. ie
i have a workbook called Master and need to collect data from a workbook
called Reports, but i need to collect it from different worksheets within
Reports depending on the month selected in Master. The tabs in Reports are
M01,M02,etc. In Master I have a Named Field called 'Month" with M01,M02 etc
entered in it. This field needs to select the corresponding tab in Reports.

 

[MLD]

Usually the reference syntax goes something like '[Filename]Tabname!Cellname
or reference.
Here is an obscure example from an old file of mine, which originally was
pointed at something on a floppy. (don't ask me why...)

=LOOKUP($B$2,'A:\[VOL2]1993COMP'!$A$6:$A$59,'A:\[VOL2]1993COMP'!$J$6:$J$59)

I need to use a named field to select a worksheet tab in another workbook. ie
i have a workbook called Master and need to collect data from a workbook
called Reports, but i need to collect it from different worksheets within
Reports depending on the month selected in Master. The tabs in Reports are
M01,M02,etc. In Master I have a Named Field called 'Month" with M01,M02 etc
entered in it. This field needs to select the corresponding tab in

Reports.