Greetings!
From your Project description, it is clear, that the problem should be easy to fix. Please provide both the working as well as broken model.
I have 18 years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation / modelling as well as dashboards for Management Reporting. In fact, over the last 15 MONTHS , I have spent at least 250 HOURS on automation in Excel every month.
I am sure I can identify and fix problem in your workbook.
Have a Great Day!
Srinivasan Krishnamoorthi