Part number lookup does not need to be .xlsm, could be .xlsx.
Cagoss85/Excel-BOM-Consenser
This macro takes Bills of Materials located on multiple excel sheets and condenses them into one. Based on code found here: https://www.mrexcel.com/board/threads/summarising-multiple-bom-tables-into-one-best-solution.801072/
Visual Basic .NET