I don't know how well this would work. I get an error that the names are macros but can't be run because they are disabled when in fact all macros in my excel sheet are enabled. Run this code and tell me what happens,.

Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
    Select Case Target.Address

          Case Range("E7").Address
              Application.Run "hyperlink_backlog_Reject_monday"
              
          Case Range("E10").Address
              Application.Run "hyperlink_backlog_Commercial_monday"
              
          Case Range("E11").Address
              Application.Run "hyperlink_backlog_Genuine_monday"
              
          Case Range("E12").Address
              Application.Run "hyperlink_backlog_Promised_monday"
              
          Case Range("E13").Address
              Application.Run "hyperlink_backlog_Age_Profile_monday"
              
          Case Else
              Exit Sub
    End Select
Scroll_Up
End Sub

Function Scroll_Up()
    Application.ScreenUpdating = True
    Worksheets("Hyperlink").Activate
    ActiveSheet.Range("A1").Select
End Function