How a drop down menu's list can change depending on another dropdown menu.

Dear Sir,

Thanks for your solution, but it creates only the drop down list and INDIRECT option gives the "#Ref!" error, I want to link the selected name from the list to different worksheet of the same name.

Example : I have a list of vendors name like Vendor 1, Vendor 2, Vendor 3,... etc in the drop down list, If I select any name from the list it should go the respective worksheet. Like if I select Vendor 3 from the drop down list then it should go to worksheet named "Vendor 3".

Kindly provide the solution without using VB / macros.