If you come across a table on the web or in another source that you want to import into Excel, there's an import feature that does the work for you.

How to Import an Excel Spreadsheet Into Access With a Macro. If you ever wanted to click a magic button and make complex business tasks happen automatically, macros can make that wish come true.