Better way of picking out maximum values with corresponding text

[MarkMagic]

Hello, I am looking for help with a spreadsheet that I have set up for local football teams, specifically with picking out maximum values and corresponding text cells (i.e. top goalscorer, most goal assists, yellow cards etc.)

As it stands, I have done it like this (using top goalscorer as an example):

Worksheet 1: "Team 1"

Row: Column C: players' names [D: goals]
2...............Tom.........................1
3.............Richard.......................2
4..............Harry.........................3
........................................Total 6

Most =INDEX(C2:C4,MATCH(MAX(D2:D4),D2:D4,0)) [NAME on cell D5]

=MAX(D2:D4) [NUMBER on cell D6]

So, obviously, that would show 'Harry' and '3' at the bottom of the worksheet.

A stats worksheet then shows the top goalscorer for each team i.e. =('Team 1'!D5) and =('Team 1'!D6) (Harry, 3)

Then I have another MAX and INDEX formula on the stats worksheet to show the top goalscorer for all teams. I hope that all makes sense.

The only problem is that this formula doesn't allow for joint-highest goalscorers within a team or overall. Any suggestions to allow for a joint high score?

Thanks.