Hello,

Hoping someone can help me with a code to do this.

I'm looking to create a summary Workbook with a button that once clicked will do the following:
- Copy rows 10, 11, 12 from first sheet on 40+ different workbooks (they can be opened, but would prefer to keep closed in a folder)
-- The sheet I want to copy the data from in each workbook will have the same name (let's say "BOOK")
- Paste as "Paste Formulas & Number Formatting" one after the other starting on next blank row in the summary workbook sheet where the button is located


Thanks in advance!!