Getting data from table into smaller tables on a seperate sheet

Hi, I was hoping someone could help me with my spreadsheet. I would like to have a "database" like sheet, in which I can easily add new or delete existing players. From that, I would have a second sheet which would show the player information in each position. So in sheet 2 the first table will have all the ST, table 2 all the AM L etc. I would also like for each table to also add the players that can play in that position under Pos 2. I have uploaded it with 2 players as an example of what I mean.

Any help would be majorly appreciated, been stuck on this for a while and can't seem to get anything to work right.