Hi there!
In a nutshell, you need to obtain an ODBC connector for Excel, then connect to your Excel document as if it was a database, using the ODBC connector, and use the command SQLTABLES to get the list of all tables in your spreadsheets (worksheets will appear as "tables").
Then, you can run through the list of "tables" in a loop and load each "table" in a usual way, as you always load Excel spreadsheets, replacing the Worksheet name with the "table" name that you received from SQLTABLES.
I'm showing a very similar example in my book (see below), even though it's not about Excel, but the logic is practically the same.
Cheers!
