Jump to a TAB from a Drop-Down Menu

[gauravvadehra]

Hi,
I have an excel sheet with multiple TAB's. Each is a Product Name and that TAB contains that product's Buyers List and email address.
This will obviously keep increasing over time and difficult to keep scrolling through to find the product TAB.
I want to create a 1st PAGE or 1st TAB who has a simple Drop Down Menu showing Name of Each PRODUCT TAB and once o select it, it takes to that that TAB.

I have made a rudimentary screenshot of what i need.

If someone can help me, please do let me know how this can be done?
Thanks so much !

 

[gauravvadehra]

and everytime i shift from Database to Dashboard sheet, i get an error that says "Run-time error "9" Subscript out of range

 

[gauravvadehra]

and everytime i shift from Database to Dashboard sheet, i get an error that says "Run-time error "9" Subscript out of range

DONE !!!

Its working - I had written settingS, instead of Setting

ITS PERFCET.

THANKS SO SO MUCH !!!
YOU MADE MY DAY>>>

 

[LongToast]

DONE !!!

Its working - I had written settingS, instead of Setting

ITS PERFCET.

THANKS SO SO MUCH !!!
YOU MADE MY DAY>>>

Glad to read it

Actually you can add some validation to it, to avoid someone doing "typo" to product name on Database sheet, you can try to learn how to use UserForm to make some validation for input data.