As long as they are the same format you could do it with code. Create a form. Create a button on the form. In the event "On Click" of the button put the following line of code:
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel97, "tblName", "filename"
for each spreadsheet you want to import, you will need this line with the file path and name in quotes. I have never played with this import, I usually import in text. You may need to read up on the TrasferSpreadsheet method. Once you get it working, just use it for each spreadsheet.
If this is going to be some sort of automated thing and you want the user to enter the spreadsheet name, you can use a variable instead of putting the file name in quotes. Hope this helps.