Macro to highlight a certain row

Before I go any further I must say I am certainly no expert with VB coding or advanced macros, but tend to get the job done by copying bits of code from various web pages.

I have a combo box linked to a list of 100 or so newspaper titles. As you know when a user selects a choice from a combo box it updates a number in a chosen cell. I need a macro to attach to this combo box so that when a choice is made it jumps to the row on another sheet in the workbook. The row would be the same as the number generated from the choice of the combo box.

I originally tried this code all the way up to 150, (which took ages to write!) but it doesnt work (??) after number 35 for some reason. Does anyone know an easier way of doing this?

Select Case UCase(Range("Z1"))
    Case "1": Application.Goto Reference:=Worksheets("Newspapers").Range("A1"), _
    Scroll:=True
    
    Case 2": Application.Goto Reference:=Worksheets("Newspapers").Range("A2"), _
    Scroll:=True
    
    Case "3": Application.Goto Reference:=Worksheets("Newspapers").Range("A3"), _
    Scroll:=True
    
    Case "4": Application.Goto Reference:=Worksheets("Newspapers").Range("A4"), _
    Scroll:=True

This has already taken up more time than I have. Any help would be most appreciated.

Thanks