Qlik Sense Loop through multiple excel documents and sheets

[DataWhisperer]

Good Day,

I have multiple excel documents which I am trying to import into Qlik Sense, the files are such as the following,

StockAudit_2021.04

StockAudit_2021.05

StockAudit_2021.06

Each of these excel documents has the same structure, there are multiple sheets with only 2 columns present - 001 and Second Hand on each sheet.

I am trying to create code to cycle through these files and check for new ones and then add that file along with all that files sheets into the model.

Any ideas on how to run this in Qlik sense?

[Taoufiq_Zarra]

@DataWhisperer 

I recommend to study the code in the link

https://community.qlik.com/t5/QlikView-Documents/Load-Multiple-excel-sheets-using-For-loop/ta-p/1489...