Copying data with header Name

[vmjan02]

I have one sheet by name "N OLT Raw" (record start from E8) and the said headers (headers are not required) need to be copy and pasted on sheet Combined, the header names are
1, Short name
2. NE_STATE
3. ALU - OLT - SNMP Avg Availability %
4. ALU - OLT - Avg CPU Utilization %
5. ALU - OLT - Avg CPU Utilization %

I have one sheet by name "H OLT Raw" (record start from E8) and the said headers (headers are not required) need to be copy and pasted on sheet Combined, the header names are
1. Short name
2. NE_STATE
3. Ping_reachability % - A
4. Avg CPU Utilization % - F_Corrected
5. Avg Memory Utilization % - F_Corrected

Any vba code to do the need full as I tried a lot but no luck till now. So I come to esperts.