Ranking scores/names from multiple sheets on summary page

Instructions are on the first sheet...

I did try and get those to work as they seem to be the answer. It should be pretty simple, I just don't use Excel too often and couldn't quite grasp how to make them work across sheets. They seem to want columns and such that are next to each other.

Thanks again, really appreciate it...