Linking web data in Excel

Hi there
I have a spreadsheet where we store our products, as a reseller we have a buy price and this will be in different currencies as we import from various international suppliers.

The challenge is that when we purchase new stock we need the latest currency exchange rate to work out our buy price. We usually have to look this up on the web, then update our spreadsheet but a colleague of mine did some training recently and was shown how to set up Excel to this for you!

Please can you let me know how we can achieve this?