How to read multiple excel files in a folder and multiple sheets in an excel file?

Yes that is also possible. You can just tell the loop end to accept all kinds of Columns and data. You will then have to sort them out later. I have added a function where you store the source of you data since that might play a role.

The whole structure then is somewhat messy.

kn_example_multiple_excel_sheets2.knar (106.3 KB)