VBA to Clean Large Worksheet

hello,
I need to pull data from a large live worksheet to clean it so i can feed it into another workbook.
the data i need is column C:G provided there is data in column F, If F has no data then I do not want those rows.
I tried leveraging a VBA but I must not be entering the correct requests as the data is not copying over. I don't fully understand the VBA to find the issue as am very new to amending codes and am only back to work after 3 years of new mom life and lockdown.

Private Sub CommandButton1_Click()
a = Worksheets("2023").Cells("3:6").End(x1Up).Row
For I = 2 To a
If Worksheets("2023").Cells(1, 5).Value = "istext" Then
Worksheets("2023").Rows(I).Copy
Worksheets("clean data").Activate
b = Worksheets("clean data").Cells(Row.Count, 1).End(x1Up).Row
Worksheets("clean data").Cells(b + 1, 1).Select
activatesheet.Paste
Worksheets("2023").Activate


End If
Next

Application.CutCopyMode = False
This Workbook.worsksheets("2023").Cells(1, 1).Select

End Sub

I have attached an image for reference the data i need to copy has red headings the spreadsheet is live and large- currently in table formatting and is updated regularly.

thanks
Dee