I'm looking for help on how link a master sheet to populate another sheets in the workbook

Calm down!!

1. Ensure that column headers are the SAME in both sheets.

2. In FGB, A9, copied across and dnown:

=IFERROR(INDEX(Pitcher!$1:$1048576,AGGREGATE(15,6,ROW(Pitcher!$A$2:$A$1200)/(Pitcher!$A$2:$A$1200="FGB"),ROWS($A$9:$A9)),MATCH(FGB!A$8,Pitcher!$1:$1,0)),"")

see sheet.

For other teams, change the bits in red appropriately