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