Drop Down Navigation Query

What i want to do is create a drop down list in excel on a single sheet to navigate to a certain row of the worksheet.

I thought i coudl use data validation then use some code in a worksheet change event to skip to that section like this:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$1" Then
Select Case Target.Value
Case "Test1"
Sheets("Sheet1").Range("A5").Select
Case "Test2"
Sheets("Sheet2").Range("A9").Select
End Select
End If
End Sub

Problem is it wasnt exactly what i was looking for as i cant use an array in data validation so what i thought was a good idea was a bad one.

what i would like is a drop down list that when i select a heading within it, it naviagtes me to that row where my heading is but also makes that row the row scroll up so it is at the top of the page....Hope this makes sense.

my row numbers are 4, 13, 19, 28, 37, 43, 52 62, 65 and 75.