how to automate this in vgb macro, i have tried chatGPT but it doesn't work

(please see attached pic below)

I want to automate copying from cell m2 to m29 , then n2 to n29 ... until cell x29 in one straight column in "sheet2" starting at cell F2. thx


I found this VBA macro works, but wants know if I can make the Range F2, f30, f58 .... F310 more dynamic ? so far, they are manually calculated , thx

Sub CopyPaste()
'Sheets("Sheet1").Select

Range("M2:M29").Copy Destination:=Range("F2")
Range("N2:N29").Copy Destination:=Range("F30")
Range("O2:O29").Copy Destination:=Range("F58")
Range("P2:P29").Copy Destination:=Range("F86")
Range("Q2:Q29").Copy Destination:=Range("F114")
Range("R2:R29").Copy Destination:=Range("F142")
Range("S2:S29").Copy Destination:=Range("F170")
Range("O2:O29").Copy Destination:=Range("F198")
Range("U2:U29").Copy Destination:=Range("F226")
Range("V2:V29").Copy Destination:=Range("F254")
Range("W2:W29").Copy Destination:=Range("F282")
Range("X2:X29").Copy Destination:=Range("F310")
' Repeat the above line for any additional ranges you want to copy and paste
End Sub




Capture.JPG

go to sheet2 in "F1"
=Sheet1!M1
copy paste across.