The scenario:

I have an Excell sheet that I want to keep up to date prices on widget X, Y
or Z from different websites. I know how to make a hyperlink to a specific
website. However, is there a way to scan or link directly to a changing value
on the site.

The Bottom Line:

I want my spreadsheet to have cells that update each time I open it with
updated prices from various websites.