Hi. I would be able to automate most, if not all of this, with macros. I already have a plan in mind and in fact did a very similar project for another client just last night, adding to my 100% completion rate! (Please see my profile/feedback).
You'll also notice I'm an excel expert with a high reputation for 100% accuracy, excellent efficiency and great communication. You can put your trust in me knowing that you're hiring a professional who strives for perfection, and my turn around times are always awesome. I have a total 10+ years in the IT industry including two Micrsoft Professional Certs.
I look forward to working with you on this and building a healthy working relationship. Please send me the source file and I'll work on it and get it back to you today, then you can award the job and pay, I'm fine with that. Regards, Kenny.