I need a formula that will rank based on highest data

Hi there, I need some help in finding a solution to my problem. I am building a football stat database which I am looking to put in an individual sheet which will search the other 20 sheets, collate the information and then display a top 5 ranking in each area. For example, this is our setup for the data:

Screenshot 2014-03-12 21.56.18.jpg

So what I want to to is have a separate sheet which will have a section for say over 1.5 goals %. The formula would go and retrieve all of the % results for each individual team. Then it would rank the 5 best teams and display the team name in the first cell and the % in the other cell.

Is that possible? I just can't seem to get my head round trying to do this.

Thanks

Andy

That would work for the one workbook, however, is there a way to get excel to rank and display a top 5 itself? The reason why I ask this is I would like to be able to run this across multiple workbooks with about 100-120 teams. What I don't want to do is have to have list the whole 120 teams so that they become ranked.

goals template.xlsx

I have attached an idea of what I want it to look like once excel has generated the ranking and the content from the rest of the workbook. I just cant figure out how to get excel to do that part.

Thank you for the last post, I really appreciate it