I have numerous Excel workbooks in a single folder that I want to combine into a single Excel workbook. Each workbook only has 1 worksheet. Each tab, or worksheet, has a unique name (this seems to be source of my confusion). The schema is identical across all of the Excel workbooks. How do I combine these into a single Excel workbook?
Thanks!!
MR
Hi @MR take a look at attached workflow.
It creates one output file with Sheets from every xlsx file in a choosen folder.