App Insight for Company Contacts

What would be the best way to accomplish this? I would like HR to maintain it as far as adding contacts and job sites when they are created. I have set up a Google sheet with a tab for Offices and another tab for contacts. Many users can be at a site and they change all the time. I would like to do a layout similar to the attachment with a view for all offices as well as selecting individual offices.

Not a very supportive community or nobody knows how to say this can or cannot be done.

Sometimes things don’t get answered. Deal with it.

You can use regular tables and refs in combination through a virtual column to get something like this done. Not sure how to view all though.