Auto sort macro for ScrollBar event

Hey all,

I am currently trying to do something similar as to what I found on this forum, which is trying to automatically sort data in a bar chart when I change the ScrollBar. I have been working on this for some time now and I cannot figure out what exactly I am doing wrong. In my excel file, I have the following: I have a Main Graph sheet which contains the bar chart and the scroll bars. The only other tab that I am currently trying to get to work with this is the Clutch sheet. As of right now, the way this is suppose to work:

On the Main Graph Sheet, when you move the Scrollbar under Blocks Rating, it should change the value in all of Column G in the Clutch Sheet. If you also change the Steals Rating, it should also change Column G in the Clutch Sheet. I plan to eventually do this for all other sheets within the excel file, and would like to know if I could have the data in the Main Graph be varied when someone chooses what data they would like to see in a drop down menu. This is the current Macro that is in place. Could anyone help? I've been stuck on this for 6 hours.

Private Sub Worksheet_Change(ByVal Target As Range)
    If Not (Application.Intersect(Worksheets("Clutch").Range("G:G"), Target) Is Nothing) Then
        DoSort
    End If
    
End Sub

Private Sub DoSort()
    Worksheets("Clutch").Range("A:G").Sort Key1:=Worksheets("Clutch").Range("G2"), Order1:=xlDescending, Header:=xlYes
End Sub

Private Sub ScrollBar1_change()
    With Sheets("Clutch")
        .Range("A1:G205").Sort .Range("G2"), , , , , , xlYes
    End With
End Sub