Copying Rows from One Sheet to another pivoting off of specific info

My issue is that I get tons of information everyday that needs to be moved from a raw data tab to individual office tabs. I attached a sample grid. What I need this to do is be more automated. In other words, I want to take the raw data I get from our parent company everyday and copy and paste it to my local grid on the raw data tab. Then I want to run a macro maybe, or something that will recognize the office that record is affiliated with and then copy the whole row from the raw data tab to the individual office tab. I do everything manually right now and it just takes too much time. I need the records on the individual office tabs to post in a new row and not write over any records that are already there from previous dates. Any help would be appreciated, thanks in advance.

I would be adding it to the raw data tab. These are monthly reports so each raw data tab gets new information added in everyday until the end of the month. Then I start a new one for the next month.

Would there be a way to do this using formulas instead of macros? The only reason I ask is because these grids are on Google Docs and I don't think they support macros. If not, that's fine, I still use local excel grids that would need this as well.

No, that wouldn't work for this grid. The reason is because the other offices have to notate the records on the individual office tabs. In other words, every day the GM's of the outside offices will go on to the Doc and put a note in the final column of the record to explain why this record was on the report. If a record is on there, it's because it was a problem. Unless the same records would be going to the same rows each time no matter what, that wouldn't work.

I probably should have been a little clearer about the stipulations as well. I have about 7 of these grids. Each one is for a different metric that we are judged on by our parent company. For example, one is for customer surveys. In the raw data tab, I keep all of the surveys, good or bad. I need to because these surveys are out of 10 points and I need to keep a running total on several different levels. One is the company level, then down to the individual office levels and, finally, the individual sub contractors with in the offices. If the survey is below a 9.8 it is considered to be a failure. Therefore I need something that would check the column for total score and see if it below a 9.8. If it is not, then nothing needs to happen. If it is then I need it to look at the office column, copy the record and then move it to the corresponding office. At which time the GM would go in there and notate the reason for the failure. Unfortunately, all 7 grids are for different metrics that look at different things. I figured once I knew how to get excel to copy the record over, I could figure out how to change the parameters it uses to find the records. Does that make sense?

Actually, I don't think Docs uses Macros but I saw Zoho this morning and that looks like it does. I can change to Zoho if that would make this work.

It's an on line spreadsheet. It's basically like Google Docs. I checked it out and it seems to support macros so if that is the solution here, I can change my reports from Google Docs to Zoho if needed.

While researching the problem, I came across another possible solution. I was thinking that instead of a macro or formula, would there be a way to show a filtered view of the raw data tab on the other sheets? In other words, I was thinking there may be a way to have one sheet of the report to be the raw data tab. Then I could have 6 more tabs representing each of the outside offices. These 6 tabs would just be a filtered view of the raw data tab, only showing data the pertains to that particular office. I am not sure how to do that without putting all of the raw data on all 6 tabs. That would make the spreadsheet way too big though. Is there another way?

Any luck here? Any help with this would be greatly appreciated.

Nothing here?