Hi everyone

I have a quite simple Excel sheet with two tabs in it (Sheet1 and Sheet2)

Sheet 2 contains numbers in row Q and hyperlinks in column T
Basically any time when there is a number "1" in row Q, macro should copy paste hyperlink from reflective row to A4 in Sheet1, call few macros and then move back to Sheet2 and proceeds to another row with number "1" in row Q

So far I came up with this but I am not sure how can I add copy-pasting from one sheet to another into loop

Sub ScrapingAllTransfermarkt()

    Const START_ROW As Integer = 1
    
    For I = START_ROW To Cells(Rows.Count, 1).End(xlUp).Row
    
    If Cells(I, 17) = 1 Then
    
    Call transfermarkthome
    Call storeDataTransfermarktHome
    Call TransfermarktHomeClean


    End If
    Sheets("Sheet2").Select
    Next I
    
    End If
    Next I
    
End Sub
Will be grateful for any help!