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.