Extracting data from raw file to another file

Hi, all

Previously I have 2 sheets, DTE and DTE_Raw in the same Excel file. But this time, the DTE_Raw has been exported to its own Excel file with its location at desktop.

Originally my DTE_Raw only has parameters: Plant, Event Start Date, Year-Month, product, Average Stop Hours, Main and Comments
But my new raw file has more addition of parameters, hence the copy pasting code would need to be altered too, I believe.

My excerpt of code originally looks like this:

Please Login or Register  to view this content.

This code was supposed to filter the parameters in DTE_Raw which has the same plant and year-month and then, copy paste the data to DTE sheet. Next, with every 5 plant, the header of the table in DTE sheet will duplicate itself (insert copied cell function).

May I know how may I alter this code? Hereby I attached both Excel files, one raw file and another one has the table. In the raw file, I have to delete the rest of the data due to confidentiality matter but the location of the parameters would be just like that in the raw file.

Hope anyone can give me a hand in this. Thanks!

Anyone willing to give me a hand? Thanks in advance for your help! Would really appreciate any hand.