Sorting with name ranges and indirect

Hello Excel lovers,

I think the picture and the file is pretty clear and visual to understand my need.

I have 3 teams with some operators in each.

With the use of the name range and indirect, i can correctly sort, but i need to set the database like this :

Team1
Op1Team1
Op2Team1
...

I need my operators to stay in the same cell,
But he can go to the Team2 or Team 3

Doable with name range and indirect?


Capture.PNG


Thank you