Automotive Analysis

I am working for an automotive group and would like to design something to: A) Take an excel of a monthly financial statment and? ? ? ? ? ? ? ? ? -Run a monthly analysis of it (i.e. net margin ratio, etc) ? ? ? ? ? ? ? ? -Use it to automotically input in the budget and forcast model B) Take an excel export of the DMS of specific vairable (new, use, f&I sales) and fixed (service, bodyshop and parts) to: ? ? ? ? ? ? ? ? -Track current progress ? ? ? ? ? ? ? ? -Match against budget ? ? ? ? ? ? ? ? -Run specific reports I believe this would require some time of either ? ? ? ? ? ? ? ? -Excel programming that would automatically pick up the excel file from the folder, extract the information, and import into a pre-designed excel template ? ? ? ? ? ? ? ? -Access database to import excel file, automatically adjust it to represent true fields, export ? ? ? ? ? ? ? ? -Some type of front end program and back end? database that will import excel or csv or etc., file, and import it into a database which can then be extracted accordingly. I am completely open to your ideas and recommendations with how you would like to do this.