This post I guess is not just geared towards excel but any program that anyone may know of that can help me here. I want to give a general idea of what I am looking for and see if it can be done by simply using excel or if I may need to get another program in the mix.

I work for a company that has multiple branch locations and each location uses upwards of 50 different subcontractors. Our parent company sends us statistical reports every day that outline our performance in the field in many different categories. I have running excel grids I keep for each metric. Each excel file has a raw data page that contains customer information and the outcome of each appointment, a pivot table for overall office performance in that category and another pivot table for individual subcontractor performance in that category. Everyday I take the raw information sent from the parent company and update the raw data tab which in turn updates the pivot tables. I then take the pivot tables and any "Problem Appointments" from the raw data tab and copy them onto Google Docs so the branch locations can see their performance and notate individual "Problem Appointments" with a reason for the problem. What I want to do is just to keep one master file. Each tab would be a metric that we get reported on by our parent company. Every day I would take the raw data from the stat report and add it to the raw data tab for the corresponding metric. From there, this program or excel, would automatically populate my local excel grids and the google docs grids automatically.

If anyone has an idea if this can be accomplished within Excel or I should be looking for another platform, please let me know. Thanks in advance for any direction here.