Within Microsoft Excel you can leverage the Web Query dialog to retrieve
information from a web pagae and place it in a spreadsheet. I have two
questionsL

1. Can this be done via a function or macro call?

2. If not can the URL associated with the web page by dynamic, allowing you
to reference a cell which would contain the string you want leveraged?
Enabling you to change parameters based upon other cell contents.