As an IT Project Manager and developer with over 20 years of experience, I can confidently say that if there's anything I know like the back of my hand, it's Excel and its macros. Throughout my career, I have devised and implemented complex solutions using Excel and Visual Basic, quite similar to what your project entails. From intricate formulas to extracting data from various sheets and generating output files, I've done it all.
Besides being a seasoned Excel expert, I have also worked extensively with data. Understanding it, handling it, and making the most of its complexities is a strong suit of mine. Combining this skill with my proficiency in VBA for applications, I am confident in my ability to build a program that can automate your consistent format uploads, apply predetermined complex formulas as required on the entire sheet's data, and successfully deliver the desired output file.
In order to put your mind at ease about what I bring to the table, I invite you to review some of my previous projects where I've demonstrated similar skills. My track record proves my expertise as a reliable and highly competent Excel macro handler with an acute eye for detail in dealing with even the most complicated datasets.