I suspect that you could create a procedure that stepped through all the
worksheets, if they were named/numbered in a consistent, predictable
fashion.
But before you consider this, be aware that the way that data gets organized
in spreadsheets is fairly unproductive if imported directly into Access
tables. Have you looked into how you will normalize your Excel data before
proceeding in Access (if this step is necessary)?
Regards
Jeff Boyce
Microsoft Office/Access MVP