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