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!

SHEET1
RANK	NAME	AGE	JS	JJ	SB	AVG
2	Evans	22.5	1	2	3	2.00
3	Beckham	22.0	3	3	1	2.33
1	Brown	21.0	2	1	2	1.67

<tbody>
</tbody>

SHEET2
RANK	NAME	AGE	JS	JJ	SB	AVG
3	Johnson	25.6	1	5	3	3.00
1	Elliot	22.0	3	3	1	2.33
1	Bell	25.5	2	1	2	1.67

<tbody>
</tbody>

FINAL
RANK	NAME	AGE	JS	JJ	SB
1	Brown	21.0	2	1	2
2	Evans	22.5	1	2	3
3	Beckham	22.0	3	3	1

<tbody>
</tbody>