I have 70 Excel workbooks (in .xlsx format) that I need to import into Mathematica.
The first workbook contains the following table:
The second workbook contains the following table:
and I have 68 more workbooks that obey the exact same format.
How can I import those 70 Excel workbooks into Mathematica; so that I can in turn export them into a single Excel workbook that contains 70 worksheets? The first worksheet could be called "221100"; the second could be called "221200"; etc.
Thank you!