HELP with copying/pasting specific range into different workbook

I am trying to figure the VBA code to copy the contents of a certain range that always occurs in the same place over the course of 478 worksheets, and then paste this information in successive rows in a different workbook.

Here is my code:

---

Sub Macro1()
Dim ws As Worksheet

' Macro1 Macro
'

'
    Windows("SurveySummary.xlsm").Activate
        For Each ws In ThisWorkbook
            With Range("C4:J4").Select
            Application.CutCopyMode = False
                 Selection.Copy
         End With
    
        Windows("RFP Comparison Base - automation.xlsm").Activate
    
        Range("B8").Offset(1, 0).Select
         ActiveSheet.Paste
    Next
End Sub

---

Any help would be much appreciated!

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here