Greetings!
I have read the requirements and understand what needs to be done.
I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of modelling similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last 12 MONTHS , I have spent at least 225 HOURS on automation in Excel every month.
If awarded, I can get your work completed to your fullest satisfaction.
Have a Great Day!
Srinivasan Krishnamoorthi