How can I import an Excel spreadsheet from the web into a current worksheet?

We have a company intranet with a link to the Excel spreadsheet that is
updated often. I would like to create a macro to go out to the site and pull
the spreadsheet into one of my spreasheets.

Any help would be great.

Thanks
Mike