Is there any way I could get around manually typing this? It's quite tedious to find and type 300 ranks about 5 times.
Yep. There's a trick that I use, and it incorporates the web browser, Word and Excel.
Go to the source web page and copy the data you're interested in. Paste it into Excel. If it's already in tabbed format, each column of data will be in a different cell column. If it isn't you have to put it into tabbed format in Word.
Paste the text into Word. Use the "Replace" feature under the "Edit" menu. If your data was not in tabbed format already, it is probably separated by spaces.
In the Replace field, press the 'spacebar' once, twice, etc. to enter a space consistent with the gaps in your pasted data (nothing will appear, but the cursor will move)
In the Replace with, press "Ctrl-T". This puts in a tab.
You may need to put a carriage return as well, this is "Ctrl-P" for paragraph.
Press "Enter" or "Replace" and all your spaces will be replaced by tabs. Test this out a bit so you get the hang of it.
Now past all the data into Excel. Chances are, the name will be in one cell. Copy this column, paste it into word, and make another tab between the names.
Copy these newly created two columns back into Excel, and the name should be split between two cells. It is now sortable.
Repeat this for other sites rankings, but in a different spreadsheet for each site.
To get the names in the same order (roughly-some sites don't list all the same players) simply alphabetize by one of the columns, I use last name. MAKE SURE YOU SELECT THE ENTIRE ROW OF PLAYER'S NAME AND RANKING otherwise you're rankings will be screwed up.
Once you have one spreadsheet organized by last name, paste from the other into your "master" (the first sorted or another file altogether). Then you can carry out your averages for the placement of all the players, or whatever other manipulation you'd like to do.
I didn't quite understand the last part of your post, so I won't comment on it.