use results from filtered table

If you could provide a sample sheet (no personal info) we could help more but in general you probably can do this with a pivot table or manually using FILTER(). I would recommend you 'format as table' (see home tab) to more easily refer to the columns of data. If I assume you do that and then click on the 'Table' menu and name that table 'Data' then something like:
=SUM(FILTER(Data[Hours], (Data[Name]="Duane")*(Data[property]="A"),0))
to get sum of hours for Duane for property A but I would replace both "Duane" and "A" with references. For example in sheet 2 you can have cell A2 be =SORT(UNIQUE(Data[Name])) to get a full list of names from the other table and then in B1 be =TRANSPOSE(SORT(UNIQUE(Data[Property]))) to get a full list of properties in row 1
then in B2 you would have:
=SUM(FILTER(Data[Hours], (Data[Name]=A2#)*(Data[property]=B1#),0))
but that is just a manual reproduction of a Pivot table but if you know how to do that you could tweak it for more customized calculations/manipulations if needed (e.g. incorporating the max hours per location and such but not sure how that all plays in). But if not need I would just do the pivot table and you're done.