Filter data from table 1 on multiple sheets (Pivot table?)

I presume this is an extremely simple task but my Excel knowledge is limited.  

I have a table of Users I've exported from our AAD. We have multiple office locations so I want one sheet per office location. I've tried using a Pivot table but it's not doing what I thought it should do. 

So, let's say column J is officeLocation and I have 7 office locations. I want a sheet for each office location based on the filter of column J that looks like and includes all the columns from table 1.  

Essentially, I want 8 sheets with the same dynamic data but have different filters applied to them. If I add a row or update a cell on table 1 / sheet 1, it should be reflected on all the other tables. Likewise, when I add a row or update data in the New York sheet, it should be reflected on table 1.  

When I try using a pivot table, I'm getting all sorts of weird stuff that's not helping at all.