input a weekly report and output data analysis

I am a fedex contractor for a trucking company. I receive weekly settlement report and It gives miles and fueling info about each truck, This data is also used to calculate payroll and to understand how each truck and drivers are doing. Right now I import the settlement report into my excel template and get the output. But each week's data is in it own file. All the implementation has been done using functions and equation so it is not a fully automated design. I would like to find a solution where the output is well organized and longer term data can be analyzed together when I want to see patterns over multiple weeks or whole year. I would like to share my template so a program can be developed. Programmer must be skilled and experienced with making such products.