Org Shaping Logic

Hi Folks,

A little stumped here. My company has a document that shows reporting relationships up to 6 layers. What I want to do is to create some of these layers as drop down filters and to show some org breakdowns. Below is an example of the data:

For example, Colonel Bluegrass is an individual contributor and Jack Bauer is his manager. We then look at Jack Bauer. Magilla Gorilla is his manager and so on as we go across. In this case, Colonel Bluegrass is low on the totem pole and Matt Trakker is the top-most layer and Colonel Bluegrass should fall under Matt if I selected Matt's name. Additionally, I may need to do a drop down for Mgr5 (Rainbow Brite) and get all of the people under her. So if I wanted to see Matt Trakker's organization, I would want to see all of those people under him by selecting his name on a drop down. Same with Rainbow Brite. Does that make sense?

Here's where it gets sticky. Sometimes a person may not have 6 layers of management because that person's manager could be an SVP or even the CEO. In this case, we have Iam Mumra who reports to Magilla Gorilla, who reports to Rainbow Brite and rolls up under Matt Trakker. 

Now if I selected "Matt Trakker" from a dropdown, how would it know to pull Matt Trakker from Mgr6 field and Matt Trakker from Mgr3 field? Iam Mumra is a higher level than Colonel Bluegrass because Iam Mumra could be a Director and Colonel Bluegrass could be an individual contributor. 

Mgr 1 is the lowest level of management and Mgr 6 is highest. 

Any help would be great here. I'm just completely stumped. I need this to be dynamic because we have leadership and management changes all of the time. So I need it to reference fields, not physical names. 

Please and thank you!