Excel Macro Developer for Data Analysis

I'm in need of an Excel specialist who can accurately and diligently handle the development of a macro that streamlines my data analysis process. Project Overview: This project is to help automate the compiling of two separate spreadsheets into one and adding minor formatting and analysis to the combined audit spreadsheet. We do this step for 7 different locations, thus in total there are 14 near identical spreadsheets which are combined into 7 final output files. This includes: - Consolidating two Excel spreadsheets into one composite document. Mastery of Excel is mandatory for this task. - Handling comparative data analysis on the combined spreadsheet. Past experience with analyzing data trends and making comparisons is crucial. - Further enhancing the readability of this final spreadsheet by changing the font type and altering cell colors, which will rectify existing minor formatting issues. The ideal candidate will be well-versed in Excel and its workings, specifically macro development and data analysis techniques. A keen eye for detail and the ability to achieve fluidity in format customization would also be greatly appreciated.