Need Help with Crew Allocations

I am trying to figure out how to make something interactive so managers can allocate employees to crews more efficiently. The idea I had was some kind of interactive map that when you click on the office you would see the local manager and then the type of construction crews working there and what employees make up that crew. We're a construction company so I need to, for instance, have Aerial Crew 1, 2, 3, and Splicer 1 and 2 show up allocated to a specific office. The caveat is that the names have to be able to be switched around because we may move guys around from one office to another. Any ideas on how to accomplish this? I am using a "contact list" but I just need a high-level overview of who is working with whom every day and be able to change those crew make-ups around.