Help Automating Roster Updates by Region

Hello is there any way to create Multiple Lists from a Single List?
Capture.PNG
In this pic, I have Al listed as South Region according to the Full Roster to the far Right.
How would I get his name to automatically show in the South list like in the Pic?
Then when I change him to North Region he would automatically be listed in the North list?
Capture2.PNG

I hope this makes Sense and I appreciate any assistance possible

Thank you!

Hi,

Why not keep things simple and use a Pivot Table along with a slicer to filter particular Regions.

Hi Bryan,

I guess I agree with Richard above. See your data that starts with a 2 column table and then uses the Slicer tool to show different regions.

Slicer backwards.xlsx