Again: No need for a macro or duplicating Excel functionality in a drop-down list.

Kindly right-click the arrow buttons to the left of the sheet tabs and click the desired sheet.

There is no need to re-invent the wheel and jump through hoops to re-create native Excel functionality. Just five minutes of user education will do.

cheers,