Greetings Hiring Manager!
I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. Having worked in an Aerospace company in a role involving design of these dashboards for Management Reporting I can relate my skill sets and experience to your project requirements directly.
Actually I implemented a EXCEL DASHBOARD similar to your project description recently. I can show you some of my work if you can message me using chat window (Freelancers cannot initiate a chat with Employers on their own - otherwise I would have shared some of my work myself).
I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you.
Thanks in advance!
Have a Great Day!
Srinivasan Krishnamoorthi