Having done a similar project already, I have a sample that does exactly what you want.
Would be happy to send it, so you can judge my skill for yourself, but you made this a "restricted" project. I can't send an attachment unless you send me a Private Message first!
I can then update your existing file as soon as you pay the fee into the site and send me spreadsheet to me.
I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the Midlands across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting.
Hope you find this of interest and look forward to hearing from you
Bob Allen-Turl