Web Scraping Data From A Website Where Hyperlink Does Not Change

Depends entriely how the web page is loaded, for example, if the structure is built into the original HTML, you're golden and can just rip the html out form the site, but if the content is dynamically loaded then you'll have a hard time.

To scrape the html use the following (shamelessly stolen from http://www.wiseowl.co.uk/blog/s393/s...ite-html.htm):

Please Login or Register  to view this content.

Now that you have the HTML as a string, you can manipulate it to get the data you need. As stated before though, this only works if the html content is not created on load (as quite a few websites are starting to do to prevent this sort of manipulation)

Use WinHTTP rather than IE automation.

It's going to be impossible for me to help thoroughly without seeing the actual link, but you should probably look at the site traffic to see what exactly gets called when you click one of the products.
Could be two things

a) The site pulls the information from another (internal) link quickly either in json, table or jscript form
b) The site actually has all the data in it already, but hidden in tables and showing on click.

Either of them are relatively easy to handle generally, but as said, it really depends on what's the ACTUAL link.
Feel free to send me a private message with more info.