Loop Through Queries

[helpexcel]

Hi I'm using this code to pull in queries and I'm wondering how to loop through reference rows. So the 1st query is in C69, the last is in C80. Each new query would start in row after the last entry of the previous one.

Dim rngAnchor As Range
Dim strQuery As String
        
strQuery = ws6.Range("C69")
     
With ws2
    Set rngAnchor = .Range("A2")
        With .QueryTables.Add(Connection:=strQuery, Destination:=rngAnchor)
            .Refresh BackgroundQuery:=False
        End With
        LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
        .Rows("3:" & LastRow).RowHeight = 12
End With

 

[helpexcel]

To clarify the queries are URL links in C69-C80, that I'm looking to pull into one spreadsheet.