Formulas or VBA better for this application?

Good morning all. I need to sum quantities of parts on sheet "1_ImportedData" column "F" (QTY) that match a specific part number or a named range and paste the matching "Customer Name" from "ZZ_Maintenance" column "C" and sum for that part and customer. The "Customer Name" (hyperlinked to the matching Customer sheet) would go in the matching equipment column on 3_Equipment" sheet and the sum would go in the "Onhand QTY" column for that part. There is an authorized quantity which is on the "ZZ_Maintenance sheet" for each customer and part that needs to be copied to the 3_Equipment" sheet as well in the "Authorized QTY" columns. 3_Equipment in the attached workbook shows the desired result. Since I am using some Named Ranges as well as single part numbers, I have no idea which method (VBA or Formulas) would be best to accomplish this (or even if one or the other can do this on its own) so if anyone has some example code or formulas I can try, it would be greatly appreciated.

Thanks in advance,
Andrew