Updating a cell over internet

I know it is possible to update a cell over the internet. Here is what I want to do, and maybe (with some expert help) we can achieve it!

I have some end users whom are selling products.

They have a price sheet on a workbook

I want to add a button that when clicked will access a "master copy" or stored data, and return with the new prices!

Please help if you know a way!

If the data you want to update from on "the internet" is available as a web page, you can create a reference to it using Data, From Web (in the External Data block in the 2007 ribbon). It will create a reference to table in an HTML page and can be refreshed any time the user wants. The update process is pretty simple, right-click and select Refresh from the menu. If that's not simple enough you can add a macro to do it and a button to run the macro.

Attached is a quick & dirty example. This pulls currency exchange data off a web page. Allow macros to run if you want the button to work. If not, you can still refresh with the right-click menu.

If the workbook is in a folder on a website that the users can access, then it would be possible to open that workbook & import the new price list.

Attach example workbooks

This would be a good way, simply let's the user download an updated workbook & replace the existing one