Auto update

ok guys heres what i want to do

i have an input page with all the players from our fantasy football league

now what i want to do is press a button and it will collate all the data from these pages

http://www.dreamteamfc.com/fantasyfo...List.aspx?pp=1
http://www.dreamteamfc.com/fantasyfo...List.aspx?pp=2
http://www.dreamteamfc.com/fantasyfo...List.aspx?pp=4
http://www.dreamteamfc.com/fantasyfo...List.aspx?pp=6

and input them into a sheet called "AUTO"

so every time i hit the button it pulls the data from the web and inputs it on to sheet "AUTO"

I then want it to look up the players numbers which are on sheet "INPUT SHEET" and tally them up with the new "AUTO" sheet so these are updated automatically.

if anyone could help with this it would save me no end of time

regards

Hi
The macro in auto sheet downloads the players' data Paste the players list in col A of input sheet and run the second macro.
Ravi

Hi
Here is a modified version of the above macro.It keeps collecting data every 15 min. as long as the workbook is open. Let me know if it meets your requirements
Ravi