Formula VLOOKUP while ranking values

[astrophys]

Hello,

I have a total of 3 worksheets. On the first two, I have a formula to rank the averages of each player. And, I have created a FINAL worksheet to include player's rank and at the same time I want them to sort (lowest to highest) from their average on the previous 2 sheets. I have attached an example and currently have the players from Sheet1 how I want them...now I just need to incorporate Sheet2 to where Bell should appear between Brown and Evans on the FINAL worksheet and so on. There is no option for me to attach, so below are my tables (sorry). Can someone please assist me?

The formula thus far on the FINAL worksheet for the RANK column:
=IFERROR(SMALL(Sheet1!$A$3:$A$250,ROWS(FINAL!$A$3:$A3)),"")

For the REMAINING columns:
=IFERROR(VLOOKUP($A3,Sheet1!$A$3:$F$5,COLUMNS(FINAL!$B3:B3)+1,0),"")

Thank you in advance!

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]SHEET1
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RANK
[/TD]
[TD]NAME
[/TD]
[TD]AGE
[/TD]
[TD]JS
[/TD]
[TD]JJ
[/TD]
[TD]SB
[/TD]
[TD]AVG
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Evans
[/TD]
[TD]22.5
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[TD]2.00
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Beckham
[/TD]
[TD]22.0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2.33
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Brown
[/TD]
[TD]21.0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1.67
[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]SHEET2
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RANK
[/TD]
[TD]NAME
[/TD]
[TD]AGE
[/TD]
[TD]JS
[/TD]
[TD]JJ
[/TD]
[TD]SB
[/TD]
[TD]AVG
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Johnson
[/TD]
[TD]25.6
[/TD]
[TD]1
[/TD]
[TD]5
[/TD]
[TD]3
[/TD]
[TD]3.00
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Elliot
[/TD]
[TD]22.0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[TD]2.33
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Bell
[/TD]
[TD]25.5
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]1.67
[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD]FINAL
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RANK
[/TD]
[TD]NAME
[/TD]
[TD]AGE
[/TD]
[TD]JS
[/TD]
[TD]JJ
[/TD]
[TD]SB
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Brown
[/TD]
[TD]21.0
[/TD]
[TD]2
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Evans
[/TD]
[TD]22.5
[/TD]
[TD]1
[/TD]
[TD]2
[/TD]
[TD]3
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Beckham
[/TD]
[TD]22.0
[/TD]
[TD]3
[/TD]
[TD]3
[/TD]
[TD]1
[/TD]
[/TR]
</tbody>[/TABLE]