Excel Sheet to Display results based on a value

Hello,
I am very basic at excel however i am donating my time to a local Field and game shooting club to create a sheet to manage members, create printable sheets for each group of shooters (squads) and display results.
So far i have created 3 worksheets in the one file called squads,members, results. i have created dummy members and the layout for the printable sheets and a vlookup formula for the member no that inputs their name and shooting grade. this is all working fine and i have locked the cells so they cannot delete the command.
i have also created in the results worksheet with a MAX command which displays the overall highest shooter and the score.
My question is i need to also display i list of all the shooters in their grades and their scores preferably highest score at the top and lowest at the bottom. So that it displays all the AA grade shooters and then all the other Grades.
Also is it possible to have the Members information in a completely differ Excel file and have a statistic page with a formula that shows what date the shooter attended and what targets he shot so that at the end of the year they can award the person who shot the best throughout the year and the person who attended the most?

Thank you everyone in advance if there is any more info required please do not hesitate to ask.
Regards
Anthony

Shoot.xlsxShoot.xlsx

Hopefully that attached!!
As you can see im deciding between the Vlookup and a drop list for the shooters name from the members list.

Also you can see on the results sheet that I have created a Highgun section which is the overall highest shooter for the day. I have found how to get the score and the name in for the first two places but cannot get the top ten which is what I wanted.

Wow That was quick!! its works perfect!!
Would you mind helping me with the High Gun section I cannot get the 3rd,4th and 5th result to display.
Thanks again

One other thing NFLSALES can that formula be used with the drop down box's?

ca







Hello, I have layed out the results page a little differ and think it would be great if beside the names it could have their score aswell? I have tried but those commands go way over my head and I am having trouble understanding them.
Thanks in advance
Anthony

Thank you nflsales. it works great!! you are a life saver