Consolidate multiple worksheets each with 3 header rows and variable number of data rows

I need to consolidate data from multiple worksheets within one workbook into a single sheet. For each worksheet there are 7 header rows, of which the first 3 contain data that must be transposed to the first 3 columns of the consolidated sheet. Then the data from row 8 onwards in each worksheet (to about row 21 currently, but this is variable) must be placed in columns 4 to 8 in the consolidated sheet. Just to add a final twist, there are a small number of data rows that represent the "second line" of information of the row above. However there are only a few of these, so it would not be too onerous to do some data cleanup separately afterwards in the consolidated list.
The worksheets have unfortunately been renamed (so they are not Sheet 1, Sheet 2, etc.)
A sample from one of the work sheets (named 130-PM-03B-CS) is:

Equipment Name: Product Loading Pump
Unit Number: 130-PM-03B-CS
Item Number:

Applied Canada Part Number //Description //serial number //Brand //Qty
Netsch Pump //Positive Displacement Pump //Machine # CAB90546 //Netsch //1
// //Type NM105BY02S14V //Job # 400584


I am really new to macros, so I would really appreciate some help please!

Thanks in advance
Jacqui

Jacqui,
Welcome to the forum!
Please attach a sample book that should include a desired result, i.e. before and after running the code. Please remove all confidential info. To attach a sample, go to advance then attachment.