Loop through worksheets to copy data to new workbook

I have a workbook which has many sheets with the same format like below (Under header 4 some rows are blank):

Capture.PNG

What I want to do is to loop through the worksheets and copy the data under header 4 and header 6 to a new worksheet which looks like:

Capture2.PNG

a sample is attached. Sample Data.xlsx
I have put the final format in the "to look like" worksheet to illustrate the final layout.
Really appreciate if someone could help with this!!