Linking DropDown box options to worksheets

Hi all,

Sorry if this has been asked before, I've done some research online and I couldn't find a solution, so I thought I'd ask myself!

Basically I have an intro page for a spreadsheet, with a DropDown box (couldbe Combo is thats easier) I need to have a series of options within the DropDown box, that when you click on it, links you to sheet within the workbook.

So far I have:

Private Sub DropDown14_Change()
  
Select Case Range("AR86:AR105").Text

Case "Option1t"
Range("H:\Docs\CV Tracking.xlsx#sheet3!A1").Select

Case "Option2"
Range("H:\Docs\CV Tracking.xlsx#sheet4!A1").Select


End Select
End Sub

but I've also tried:

Private Sub ComboBox1_Click()
    ComboBox1.DropDown
End Sub

Private Sub Userform_Initialize()
    ComboBox1.AddItem "Option1"
    ComboBox1.AddItem "Option2"
    ComboBox1.AddItem "Option3"
    ComboBox1.AddItem "Option4"
    ComboBox1.AddItem "Option5"
End Sub


Private Sub ComboBox1_Change()
  Select Case ComboBox1.Value

Case "Option1"
Range("H:\Docs\CV Tracking.xlsx#sheet6!A1").Select

Case "Option2"
Range("H:\Docs\CV Tracking.xlsx#sheet21!A1").Select


End Select
End Sub

but I've had no luck with either! Can anyone help?

Thanks,

Chris