Dear Sir/Ms,
I already have pieces of VBA code to search multiple files in a folder and to search tabs in a file. Also, I have held positions of Business Unit Manager and managed P&L reportings with advanced analytics so I can understand quite well your needs. You wonder why I'm applying here : I need extra money for my personal projects. I have been an excel freak since I'm 15 and my passion is to write quick, simple, efficient formulas.
By the way if you wanted, for instance, that your data keeps linked to source files and updates easily with formulas, it's something I can do. Also write dynamic formulas and dropdown menus so that the calculations don't need formulas.
For instance, the VBA code would only define sourcefiles for each date, and link data formulas to them.
Otherwise I can make a VBA macro that makes it all, with values and colors, it's just a systematic data search routine.