Ranking scores/names from multiple sheets on summary page

Both of those work great with the 6 clients, is there a way to write this formula so it will create this master table based on a range of sheets. So that when a new client sheet is added it will automatically search their sheet as well.

Is having a master table and then using vlookup the only well to get Excel to do something like this where the data is not in adjacent columns?

Hi
The macro will work for any number of clients/students you add.
Ravi

Thank you...

How can I set it up so if two people have the same score it will report the unique names.

Is there a way to add a simple command to move the score data one cell to the left, so that when the next instance runs it will not see it?

I changed the formula to fit the layout of my Summary page, so just need to know how to move it if there isn't a cleaner way.

Thanks!