How do I create a pull down menu that navigates to different sheets?

[ungoliath]

I want to create a pull down menu that I can navigate to different sheets. I've got a workbook w/ probably a few dozen sheets I am continually going to. What can I do to have a standard button or even a macro key that can pull up such a navigation?

 

[hiker95]

ungoliath,

See:

Tom’s Tutorials for Excel: Sheet Selector Drop-Down List.
http://www.atlaspm.com/toms-tutorials-for-excel/toms-tips-for-excel-sheet-selector-drop-down-list/

 

[SMB Cooper]

Using the Name Box for Quick Navigation

One advantage of using names is that you can use the drop-down in the Name box to jump to any named cell. This includes cells that might be in distant sections of the worksheet or even on other sheets in the workbook.

Name a Range - Excel Name Box

You can create an Excel named range quickly by typing in the Excel Name Box.
1. Select the cell(s) to be named
2. Click in the Excel Name box, to the left of the formula bar
3. Type a one-word name for the list, e.g. FruitList.
4. Press the Enter key.

TIP: Range names cannot contain characters that are used in programming. Those characters are: " / \ [ ] ; : | = . , ? * + < >. You cannot use spaces, however, upper and lower cases will be retained and Underscores and dashes can be used to help the readability of your range name.