Navigate between sheets by using dropdown (combo box).

Hello guys,

I basically want to navigate between the sheets using a dropdown menu. I want to click the combo box, then selecting the president from dropdown menu, I want to go the sheet with the name of the president I selected on the dropdown menu.

Like this;
1. I click on combo box.
2. I select Obama
3. I go to Obama Sheet

Please use the sheet names as I used, otherwise I may have to difficulty to solve the code.

Your helps are sincerely appreciated guys,
Regards...

Are you going to have a dropdown on every sheet?
Wouldn't it be better to use the UserForm (VBA) and select the sheet from there?
If so you then have one userform you activate with for example ctrl+4 and you pick out to which sheet you want to go.

Ok so here is my version

Try ctrl+q in this test subject and try changing between sheets.

Thanks for the asnwer.

The document I uploaded is the simplified form of the actual one. I want dropdown menu to be visible on every sheet and all the time. I dont want to activate it by another click or press. It should be constant on the screen.

So what do you suggest me? If it is simple, you can answer my very first question. How can I achieve that task?

Hey, thanks a lot for the effort. I am trying to understand now.