If this is a one-time effort, you could

(1) autofilter on the location column for each office in turn. Then
copy the visible rows and paste special values into the associated
sheet.

or

(2) if location column is A, in A2 on the office sheet (assuming you
have headers in row 1), enter =IF(Sheet1!$A2=28,sheet1!A2,"") and copy
to as many columns and rows as are in sheet1. Do the same for the
other sheets but substitute 44 and 68 for the 28. This will leave you
with a lot of blank rows in each sheet. You can bring all your
completed rows to the top by sorting.

If, on the other hand, this is something you need to do repeatedly,
please let us know, and we may devise a repeatable approach.

As an aside, will you ever need to analyze all the data across all
offices, and, if you spread it across three sheets, will that be more
difficult than if it were on one sheet. Note that you can display the
rows for one office at a time on your primary sheet using Autofilter,
thereby making it virtually the equivalent of the three sheet approach,
and yet maintaining the ability to analyze all the data across offices
more easily.

If you haven't use Autofilter before, look it up in the Help. To use
it, highlight the header row of your primary sheet. Then click
Data/Filter/Autofilter. This will put drop-down arrows across your
header row. Click on the one in the Location column and then click 28.
You should now see only the rows that pertain to offfice 28.

HTH

Declan