Importing mutiple tables with the same field names
 

I have access create tables for each sales consultant and then imported into
a workbook ( i know but thats the way they want to view it).

When i am setting up the users to import into their worksheet using the
wizard I have to click each field for the different user.

Is there a way to import each table by just changing the table name in the
query?