Hi Phil,
I went through your requirement, and this is a classic case of procurement and operations teams being on disparate system. I have faced similar situation on multiple consulting assignment, that I have worked in the past, for companies like Walmart, Dupont, Accenture, Pratt and Whitney.
I though you have come up with a nice quick fix solution using excel, and automating the addition of items not currently present in the procurement system, and I will be glad to assist you with this requirement. With over 15 years of experience in automation, and creating customized excel bases solutions, (including a few fortune 500), I have dealt with similar automatons in the past.
I take pride in the quality of work that I do, and the value add, that I provide to my customers. My charges are aligned to this quality. Of course you can try some of the $300 bidders and hopefully they wont waste your time, or you can reach out to me and I will be glad to address any queries or concerns.
Regards
Amin