I have a command button and combobox on sheet1. The combobox is a list
of the sheets by known name ie "Sales " is sheet3 "Expenses" is sheet9
etc.

The known name is at cell A4 on the relevant spreadsheet.

So if someone picks Sales from the combobox and then presses the
command button i want to go to that sheet.

What is the best way to do this please.

Bob