You can make a macro which uses the web query feature or do it
manually. Make a new web query: DATA IMPORT EXTERNAL DATA NEW
WEBQUERY 'Enter an URL'
Use a made existing web query: DATA REFRESH DATA
Pleas take a look in Excel or VBA help for more info.
Hope this helps!

- Bas