Re-Arrange Generated Data

[flds]

Hello,
I have a report generated on sheet1. I need to rearrange this data for evaluation purpose in sheet2. (See attachment).
Each time a report is generated it runs into over 100+ rows. All the row need to be captured in sheet2.
Sheet2 will have a template to capture the data from sheet1, rest of the rows to be copied in the similar format as the first set of data, the only way to do this is I believe is by creating a macro.

I would appreciate if someone could help me create a macro. I hope I have explained this well.


Thanks in advance.
FLDS