Hi,
I went through your requirement, and its a great idea to consolidate the costs in the master review sheet. I think you might need to also consider 3 things.
1> All data in the master review needs to be sorted by dispatch number and then by months. This will give you a better understanding of how a particular dispatch has been trending (cost + invoice). If this is not sorted, then it will becomes a tedious exercise to get such an understanding
2> you can consider displaying this information (from Pt1) for any chosen dispatch number graphically. It will be very effective to get a visual representation
3> Indicators: Lets assume that as a business you have a target to ensure that each dispatch had invoice 90% or 100% every month or 90% or 100% of cost. then maybe you can also have a functionality where any dispatch where this is not true can be highlighted in red, or shown as a separate report
I have over 15 years of creating customized excel based solutions for companies like Dupont, Volvo, Accenture, Pratt and Whitney. I pride myself on the quality of work I provide to my customers and the value add I bring to any project that I am associated with. My rates are aligned to this value add and quality. Ofcourse you can try some of the $100 bidders and hopefully they wont waste your time, or you can msg me and I will be glad to discuss your requirements in greater details and also talk about, what we can do to make it better and effective
Regards
Amin