Pulling info from other sheet

im trying to pull info from a sheet but when i do it repeats the same info when i pull it down

I'd Like the data to be pulled from "Game Data" sheet that match the criteria in A1 and C1 when I pull it down it only shows the same info for all games. When they have played each other 4 time (as shown in "game data" sheet highlighted in yellow) so when i change A1 and C1 to 2 different teams it should give the proper info for those teams.

this is the formula im using is

=IFERROR(INDEX('Game Data'!$D$2:$D$6000,MATCH(A$1&C$1,'Game Data'!$B$2:$B$6000&'Game Data'!$C$2:$C$6000,0)),"")

hope this is not too confusing.

thank you all for your help

Thanks for the info but as this is only a draft workbook i only included the columns i need to update according to A1 & C1 - on my original what i dont show is another ton info on the cells mentioned.

these other columns dont need any adjustment (the ones in my original book) i need the info to be pulled from the game sheet so it updates on the team info sheet -

Thank you for your pivot suggestion but id rather not.

thank you so very much for your help.