Create new workbook with selected data

[EGP2018]

Hi,

I'm looking for the most efficient solution to this problem...

I have a workbook with 30+ tabs that contains stock items, supplier codes and their prices (6 suppliers per tab).

I trying to create a new workbook that mirrors the former (data and format) but without the prices.

I've no problem creating a macro to do this, but it seems very long-winded and the new workbook takes an age to open whilst the macro is running.

Any ideas on a more efficient way?

TIA