Create 1 master excel from 2 excel

FIRST - You must to have some know a little be about cars (make, model, submodels, engine) We have 2 master excel document with part information's and another one with weight information, and we can to create 1 master file with the fallow fields. Please check the attach file for more information I will select the first person that send me an excel with 5 products already done using the MasterFile formart Thanks