VBA Code for Copy & Paste

[abid.aries]

Hi Experts,

I need a vba code to copy my all workbook sheets data / values (more than 100 sheets) and paste them in a separate sheet.

Thanks in advance.

 

[shrivallabha]

There are several codes available online which do this. Example:
https://www.rondebruin.nl/win/s3/win002.htm

You need to adopt the one that suits your purpose.