Go to Data Menu, choose the "From Web" option under the "Get External Data" section. Put a valid web page address, and click on "Import" button at the bottom.
It will put the web page content to the Excel worksheet. If the web page makes updates in the background and if you need to pull the updated content to Excel, that is easy as well.
You just have to right-click on the download content and hit "refresh." The content will be pulled again, and the new content will replace the old one on the worksheet.