Building on this great idea, here is another possibility

For those with later versions of Excel there is the option to use a Web Query instead of cut and paste. In this case you can then simply open the excel file, refresh the query, and your data will be updated.

Cheers
Stewart