Hi all

I have two workbooks: one is Master Plan and another is Stock Plan. The Stock Plan contains 500 sheets. What i want is, when I click the drop down list (which is located in the Master Plan) it will list all the 500 sheets and if i choose a sheet (let say sheet 387) it automatically hyperlink to that sheet and open that sheet. Is there any way to do that? Because right now, i'm using manual method by hyperlink the 500 sheets one by one and it really take days to finish.

i'm newbie and this really drive me crazy.

Imran