I'm expert in Macros and could do your project in a very easy way, with a Dashboard for the team leads and for the PM.
My experience for the last 5 years was managing a beauty company (family business) with more than 1000 references (ref and colour) and 14 stores in 3 countries. I created excel automated tools (with Macros) to control the stock as per the demand of each item and automated order proposals to the suppliers, data analysis with Pivot Tables and many other files, always with the business prism.
I can really help you in this project, and as would be my first one, I wolud charge the minimum fee and give extra hours to the project. Now I have free time, as I'm living in Nepal for some months (doing Excel Courses for free).
I would appreciate if we could open a chat and talk about the project, I have time these daysto dedicate to this project.
Best regards,
Albert