Adding New files to existing worksheet

[nmh7]

I have an already existing workbook with a bunch of parts. I am trying to create a macro that will take new files and add them into the already existing workbook. I have the part number, quantity and where each part was used. The original has a lot more information that I do not need. Is there a way I can just add a new file and have a macro sort out the information I need to add into the existing workbook and combine if there are duplicate parts. I will post a screenshot for what I have. The first picture is what I have and the 2nd is what I would want to add. The chart in the first picture was created using power query.

 

[nmh7]

I am going to get rid of the power query and use this picture for the file instead.