Alice, the approach I like to use is a master index worksheet at the front of the workbook. On it is a list of every sheet with the name of sheet being a hyperlink to cell A1. And, on every sheet in A1 is the word "index", and it is a hyperlink back to the master index. This avoids any code in the workbook which would not run if the user has macro disabled.

The Spreadsheet Assistant at http://www.add-ins.com/spreadsheet-assistant.htm has as one of its features a way to build such a master sheet and hyperlinks to and from all sheets.

Robert Flanagan
Add-ins.com LLC
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, fax 302-234-9859
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

On Tuesday, March 19, 2013 6:47:12 AM UTC-4, Alice21 wrote:
Hi



I have 89 sheets in my workbook, each with a unique ID number.

I want to have a Master front sheet that has a bit of information about

the system and then a drop down box that has all ID numbers in. When a

person selects a certain ID from the drop down it will then take them to

the relevant sheet.



Is this possbible please?









--

Alice21