it's a very straight forward task. As proof of concept I propose to send you a video screen capture of macro already working (would need worksheet and instructions). Timeline would be: i get files, under a day of coding, I send you video, you award me, I send macro and I wait por any correction.
I'm an engineer with extensive experience in VBA including interaction between diferent softwares (Excel, Word, Access, powerpoint, autocad, MS Project etc). I'm also a prolifient coder (c++#, vb, .Net, python and others)