Addition of common items during merging of multiple excel files

Help
1

I am facing difficulty during merging of excel files which have common items. I am attaching two excel files here. I want to see the summing result(summation of quantity and price) of the common items along with the different items in a different excel sheet. Please help…
If anyone upload workflow regarding this problem, it will be helpful to understand…
Thanks in advance…
Regards,
Apurba

Excel1.xlsx (8.2 KB)
Excel2.xlsx (8.8 KB)