Copy Columns between Worksheets (keeping fomulas)

Hi all,

I have a folder containing workbooks (A.xlsx, B.xlsx and so on) which may change daily. I am trying to run a macro from my current file POData.xlsm to transfer data between worksheets in each individual workbooks in this folder.

Basically, worksheets "Header" and "Detail" in each workbook serves as a template and "Sheet1" serves the data source. I am looping through the workbooks in C:/Files/ and for now, and copy cell D2 in "Sheet1" to cell B6 in "Header".

However, now I am stuck copying columns "B", "E" and "F' (in "Sheet1") to columns "B", "D" and "F"( in "Detail"). Kindly note that there are simple formulas hightlighed in Red.
I have also included "Details (desired)" as the output to achieve.


How can I copy/insert columns "B", "E" and "F' (in "Sheet1") to columns "B", "D" and "F"( in "Detail") while maintaining the simple formulas?


Any help will be very much appreciated. TIA.