Only show specific fields when selecting specific name from drop down lists

I have a table that I am trying to build that contains team managers and their agent names. Under Team Manager, I have created a drop down list and can select a manager from there. What I am looking to do from here is, when I select a specific manager, the tabel below will provide me with a list of agents who fall under that specific manager.
I have tried Index and Match as well as Unique funcitons. Is there perhaps another function that I could use or another method that I could try to achieve what I am after?

(Apologies, I'm not to sure how to upload a proper table into this questions)


Team Manager
Joe Bloggs (This is the drop down)


Team Column 1 Column 2 Column 3

Agent 1
Agent 2
Agent 3
Agent 4
Agent 5
Agent 6
Agent 7

Yes, I have filter option and works for what exactly I am looking for.

Thank You