Need help with VBA code which allows copying pasting data between sheets if conditions met

Hi all,
I will need to ask for help to develop a VBA which allows me to tranfer specific data from sheet 2 into sheet 1 if conditions is met.

So for example:
In Setting sheet, the information of each type of systems are separated into different tables. For example, I will need to copy information of DX Unit into the AIR Template sheet. All the information before Line 8 in Setting Sheet should appear in AIR template Line 30 and below.

And also the heading in each columns for both sheets are different. Hence, I indicated the column number which the information in Setting sheet (Row 1) should appear in which column in AIR Template sheet (Row 7) . So for example, Setting Sheet Column no. 7 should appear in AIR Template Sheet Column No. 7.

Currently, I facing trouble in developing a VBA code which able to fulfill both criteria. Will appreciate greatly for your help.
Thank you!

As this has not gotten a response in over 48 hours, perhaps a formula based proposal might be acceptable.
For E31 and down to E43:

Formula:

Please Login or Register  to view this content.

Note that if columns E:G were not merged you could simply drag the formula over, however as is:
For H31 dragged over to Q31 and then, while H31:Q31 are still selected, dragged down to Q43:

Formula:

Please Login or Register  to view this content.

For S31 and dragged down to S48:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.