What I've noticed is that when MSAccess uses the ImportExportSpreadsheet function to export data to excel, it will create a new workbook within the spreadsheet.

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.