Master sheet to another sheet automatically

[mreider]

I need some help taking data from a master sheet and having it filtered to another sheet automatically.

I have a Master sheet all of the players of our fantasy football league that can be sorted by Player Name, NFL Team, Position, Salary, Status, How Acquired, Contract, and Fantasy Team. I want to be able to make changes to the master sheet and have a sheet for each team where those changes can be updated automatically.

So for example I want all the players from Team 1 to be updated to Team 1's sheet. If Team 1 adds a player I want that to be updated automatically on that sheet.

It should be possible but I am really struggling. Any help is appreciated. Thanks!