Help with looping formula needed

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

Please Login or Register  to view this content.

Will be grateful for any help!

It will be something like

Please Login or Register  to view this content.