Are you doing this strictly to be taken to the desired worksheet? If so,
would right clicking on the tab navigation toolbar (the 4 VCR looking
buttons to the left of the tabs) and selecting the worksheet from the list
box that appears be an acceptable solution?

Rick


"Alvyn" wrote in message
...
Dear Sir/Mdm,

Can anyone please advice how to search for a specific worksheet tab based
on
a cell value (user input) on a worksheet.

Eg, I have 50 worksheets in 1 workbook.
Sheet1=Main Menu
Sheet2=Customer ID 1
Sheet3=Customer ID 2
Sheet4=Customer ID 3 and etc.

If I input a value say "Customer ID 45" in a cell in Main Menu (Sheet 1),
how can Excel "intelligently" brings me to Sheet 46 which is also Customer
ID
45?

Thank you

Alvyn