It worked!

Thanks guy's.

Cheers,

Steve

"Vasant Nanavati" <vasantn AT aol DOT com wrote in message
...
I think you missed the closing double quote. <g

=INDIRECT($M$1&"!A1")

Of course, this is assuming that it is a Data Validation dropdown.
__________________________________________________ _______________________

"Pete_UK" wrote in message
ups.com...
You'll need to use the INDIRECT function, something like:

=INDIRECT($M$1&"!A1)

where M1 contains your pull-down. This will bring the value from cell
A1 of the sheet specified in M1.

Hope this helps.

Pete

On Jul 15, 12:20 am, "Steven Taylor" wrote:
Hi,

I would appreciate some advise on the following:

1. I have a workbook with 5 sheets in it. The first four sheets
are

named wk1, wk2, wk3, wk4. The fifth sheet is named Summary.

2. The "Summary" sheet has a drop down box on the sheet with the

names of the first four worksheets.

3. When a user selects a value from the drop down list say "wk2",
I
would

like all the formula's on the "Summary" page now to pull the values from

the "wk 2" worksheet etc.

All comments and suggestions welcome.

Thanks,

Steve