Creating a org chart just by typing in main person.

[zero3ree]

I am trying to create a org chart by main person. What I need is if I type in a name it will list all employees that report to him. Ideally I would like it to loop right into the next one down as well. Like if someone who reports to main guy has people that report to them that there names go under them. This might be something that needs to be done in access but was hoping I could keep it simple.

I have attached the xlsx of what the table will look like and what I would like to see as results. If excel can not break out the hierarchy like I prefer if it could just list the employees for each supervisor by typing in the super would be fine.

Thanks in advance.