I'm an Excel expert. I read your requirements carefully and I confirm that I can do exactly what you need. If you want me to share some files with you, please contact me on chat. I cannot attach a file to this message or contact you first.
I'm a computer science professional with a PhD degree and extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile.
Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/
https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/
https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/