Do you meand spreadsheets or workbooks?

Speadsheets can be copied within one workbook without activating each sheet.

Workbooks have to be opened to copy the sheets, but the original workbooks
can be closed without altering the data or the data of the workbook.

"Robin" wrote:

Hello

I am new to using macros so i need some help to create a macro that copies
data from a bunch of spreadsheets(about 20) and displays the data in one
spreadsheet. Also is it possiable to do this without actually opening the
spreadsheets that I want to copy the data from?

Thanks
Robin