How to link different worksheet from the list of drop down menu

Hi Sudeep,
One way you can do this is using a macro to create a list of all sheets.
The macro is as follows-

Please Login or Register  to view this content.

Now insert a new shape and assign the above macro to it. Then click on the shape to run the macro each time.

This macro would create a list of names of all the sheets present in the workbook, starting from cell B2. Then it would create hyperlinks in the adjacent column i.e. column C.

See if this helps.
Do ask for any other query you may have.

Hope this helps!!

Regards
Sourabh

If you want it is drop down form they try this method.
Create a list ff sheets using this macro-

Please Login or Register  to view this content.

Now in Cell C2 in this case, Go to Data>>Data Validation>>List and create a drop down. The range for it should be column C in this case.
Now assign the following macro to a shape/button.

Please Login or Register  to view this content.

Now is cell C2 select the sheet you want to go to, and click on the shape/button (you have assigned the macro to), to jump to the sheet specified in cell C2.

Hope this helps!!

Sorry, but this is not possible with macros...
You can create formula for hyperlinking, but first we need the names of all the sheets in a list form which is possible only through macro as far as I know.
If you are having trouble using those macros I can guide you, but believe me they are quite easy, once you get it.