I read your requirements carefully and I confirm that I can do exactly what you need. 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.
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/