You may do the other way around.  Instead of exporting from Access to Excel,
use the menu Data->Import External Data->New Database Query so it will be
Excel the one reading from the reports in Access.  You can link to a
different report in each worksheet, and Excel will give you the option of
refreshing the data on demand.
If this solution fits you, the Excel help has a topic for "Import or connect
to data", where you can check the details on how to do it.

Hope this helps,
Miguel.