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. Please see reviews on my profile. It would be my pleasure to do your project. Please contact me to discuss the details.
It might help you to know that I own an engineering consulting company registered in the state of Illinois. You could deal with me as an individual freelancer or as a business, whichever better suits your needs.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/