Copying a range of data between 2 values

[Closed]
Report
-
Hello,

Please could someone assist. I have a workbook with 97 sheets and I am wanting to create a macro that can copy a certain range of data between 2 values from each spreadsheet into a consolidated spreadsheet.

Thank you.
Roxy