Data Base: How to Import Multi-Worksheet Excel Workbook?

Please, for full clarity, let me lay it out completely. Thank you for your patience and your responses.

I have daily record files (about a hundred thus far ... ), each a single-worksheet EXCEL workbook file; actually they are "in duplicate," one each with .XLS and .XLSX (older and newer versions, respectively) extensions. Each record comprises 11 fields.

I have also duplicated and aggregated the same daily records into corresponding, monthly (again, XLS and XLSX) spreadsheet workbooks wherein each worksheet (of up to 31 worksheets) in each month-designated workbook contains the content of one (aforesaid single worksheet) daily (single worksheet) workbook-for example: worksheet #15 in the Excel workbook entitled June Master, when that sheet tab is clicked, displays the June 15, daily file . . . a duplicate (you could say) of the aforesaid, single-worksheet Excel file for that date.

Respecting importation of the spreadsheets, it seems to me I have an option among two choices:

1. ... to import to the the data base by importing each daily, single-worksheet (say, XLSX) workbook file-a lengthy task because of the volume of daily records requiring individual importation-but highly repetitive, so fairly uncomplicated ( and presumably risk free) to perform, and/or ...
2. ... to (attempt to) import a monthly, "Master" workbook containing a month's worth of daily records as individual worksheets. (This would be done on the assumption that the "import" process would "recognize" each worksheet in succession as a new delineated record and continue automatically from sheet to sheet (from record to record) until the workbook importation is completed-hopefully without the data base's having to query me for field matching with each successive worksheet it encounters . . . as would be the case with separately opening and importing each daily file (workbook), one after the the other (as in Option 1.).

So, in respect of option 2., I need info about how the data base import feature would "handle" a request to import a master (monthly) Excel workbook comprising more that one work sheet. For example, if the Master (multi-worksheet) file was loaded into the MyDataBase program, would the import routine automatically recognize each worksheet as a separate record and proceed, in order, to import each worksheet until all worksheet (records) have been recorded in the data base?

Would there be any intervention required on my part during the import process?

Have you any other advice as to importing a repetitive-worksheet Excel workbook?

By the weigh, the data base is MyDataBase by Avanquest; but I suppose the answer would be similar for most popular data base applications.

Thank you.