VBA Index Match add Row

Hello, I am new to VBA and came up with some code that does what I need but after a week I am stuck. I have 700 files that I need to run this on . There are Files that start with PL they need to be updated using the RM File. The file that says complete is what it should look like after it is done.

Basically want to match a part number from the PL Files to the RM File if match found add row below. Copy PL file Part Number to offset -1 column in new row and the rest of the data will be filled in from the RM file. The COMPLETE file has some VBA I was able to work out but its just not coming together. Below is a image explaining the complete file.

Thank you to anyone that is able to she some light on this, I am at a dead end.

Output.png