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