ExcelBanter - Integrating a work sheet into another

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Integrating a work sheet into another (https://www.excelbanter.com/excel-discussion-misc-queries/101743-integrating-work-sheet-into-another.html)

Amature Amy!

Integrating a work sheet into another

I have 3 work sheets.
I want to copy the formats and information from Sheet 2 & Sheet 3 onto Sheet
1.
Is that possible, and if so, please tell me how to do it.
Thank you.

All times are GMT +1. The time now is 03:19 AM.