OK let's start from scratch. Open Excel go to View then Toolbars then Forms. Be sure that before the word Forms there is a check. Now the Forms toolbar is visible on your worksheet. From the Forms toolbar click the List Box icon. If you move the cursor over the worksheet it changes to a crosshair. Press the left button and drag it downwards and rightwards then release it. A List box should be created on your worksheet. In the Forms toolbar on your worksheet click on the button icon, place your cursor over the created List Box, press the left button drag it downwards and rightwards then release it. A button should be created in your List Box, and a pop-up window with the name Assign Macro appears. It assigns a macroname for the new button (for example Button1_Click). On the right side of the Assign Macro pop-up window are several buttons, click on the New button, and the Microsoft Visual Basic for Excel opens. A small window opens up with the name Book1 - Module1(Code), just an example. The cursor should be placed between the lines Sub Button1_Click() End Sub. This is the procedure I've been talking about. Now paste this code:
Sheets("Sheet1").Select
inside the procedure. Your procedure should look like this now:
Sub Button1_Click()
Sheets("Sheet1").Select
End Sub
while you're in Microsoft Visual Basic save what you've done, say Test.xls. Do the same for the other buttons in your List box that should point to the other worksheets and just replace "Sheet1" with Sheet2 and so on in the other procedures.