Copy multiple Sheets Ranges to New Book

[Emoncada]

I have A workbook that will have multiple spreadsheets.
I need to copy entire workbook but just Ranges("B1:Y65536") in all spreadsheets.

Can this be done?

[Aussiebear]

Yes, but what triggers this mass copying of ranges and where does it all end up?

[Emoncada]

I will have a cmdbutton that I want to be able to click on.
I would like all spreadsheets as they are, but in a new workbook and just the Range of columns(B:Y) in each spreadsheet.

[Emoncada]

Actually, it would be better if it makes a copy of the entireworkbook, then deletes columns A & AE then that would work.

Is that easier?