VBA for Multiple web queries

I would like to automate the following task (for personal use):

I would like to import data from this website: www.oddschecker.com

Since the data I am importing depend on the football match schedule the web query changes accordingly (every week). I have figured out how to create the relative urls which are listed in an excel sheet in column A from cell A1 up to say A100.

For example for the coming game between Manchester Utd versus Manchester City the urls will look like this:

http://www.oddschecker.com/football/...nner/exchanges
http://www.oddschecker.com/football/...ime/exchanges/
http://www.oddschecker.com/football/...ime/exchanges/
http://www.oddschecker.com/football/...core/exchanges

I would like a code to read these urls and import each one into a different worksheet of the same file.

I understand also that I might be running into cache problems because of the number of queries involved.

My VBA knowledge is poor. I am using excel 2007. OS Win XP Pro

Thanks in advance for your help

I would suggest using iOpus iMacros for this purpose. They have a Firefox plugin, or a stand alone version. It can write your output to a .csv which can be opened in Excel.