Excel provides a very useful option to gather data from websites, called web queries. These have been introduced with Excel 97 and have been further enhanced in the versions released after Excel 97.
This article shows how you can setup a web query so that you can make the worksheet dynamically update based on values in so called parameter cells.
The article also shows how to programmatically change parameter settings.
Jan Karel Pieterse
JKP Application Development Services