Hello,

I am currently trying to get prices from a website that we source products from and sell on. I want to get this information from a series of webpages, which gives details of the products, and then extract a few different parts of the webpage, and for the data to be displayed in different columns of a spreadsheet. Is there a way I can extract this data from external live webpages, and then for these figures to automatically update when the spreadsheet is opened?

If anyone can offer any guidance as to how I could do this, I would be very grateful.