Cross reference and compile sales by SKU

I have 5 yrs worth of sales in an excel sheet. It is 65,000 SKU numbers from 2014 - 2019. Then I have a master list of just shy of 2000 SKU's. I would like column D filled in on the Matrix sales workbook with total unit sales for each vendor Part # from Matrix sales column F. It would be matched up with the vendor part#'s from column G of the 5 yrs workbook. Then I would like the sales broken down by year in column E-J. I am expecting that many of the vendor part #'s in the Matrix sheet may not have sales. I am also expecting a lot of the "Vendor part #'s" from the SKU's sold 5 yrs workbook will not match up to the Matrix workbook. I would like any vendor #'s that do not have a match to be put into the Missing vendor #'s tab. All of the data from the row should accompany the missing part #'s. I believe this is pretty straight forward and not to involved.