Getting External Data.. New Web Query

I'm trying to get some data from a webpage..
I know very little about the specifics of the "Get External Data" command except that i need the webpage URL and the cell # to enter it to..

Here is a sample link for what i'm looking for...

http://www.covers.com/pageLoader/pag...referee23.html

The number "23" at the end of the filename in this case ranges from 1-46 so basically i'm looking to grab info from 46 seperate pages, and placed onto 46 seperate sheets within a new workbook...

Specifically the data i want is the table of data (jersey number, # of games, Home record, etc... and the Over/Under portion as well)....
just the tables... no other BS...

also i have no knowledge of VB or anything like that..

is there anyway i can do this with minimal stress and maximum efficiency?

thanks in advance!

To do this manually, select from the menu Data >> Import External Data >> New Web Query. Paste the address. This will bring up the web page. Scroll down to the part(s) you want and click there. The yellow arrow will turn into a green check. When you have all you want/need, click "Import". You will see it retreiving the data.

To manually update the info, right-click on a cell with data in it and select "Refresh Data".

If you do not want to do either of these 2 actions 40+ times manually (and who would blame you?), then turn on the macro recorder (Tools >> Macro >> Record new macro) while you do it once manually.

Then "Edit" the code to make it do this as many times as you want/need.

Here is the code that the macro recorder gave me for refreshing one of the Web queries ...

Please Login or Register  to view this content.

Here is how I would re-write that in order to refresh every query in the workbook.

Please Login or Register  to view this content.