Hello everyone,

I have a document with multiple Worksheets (in the example i attached there are only 3), each Worksheet has the same type of data in the same format.

I would like a script that can do the following in a different Worksheet:

- Copy some of the data from each sheet into a new one
- Separate the data from each sheet by one row and have that particular row named as the name of the worksheet of which the data will be next (if it is HC then the row that separates the RH issues from HC issue be named HC)

I have attached an example of what i am talking about.

New Microsoft Excel Worksheet.xlsx

Thanks you in advance for your help,
-Alex