Loading Multiple transformed Excel Sheets

[#1]

Good day,

I have a client who runs his company from monthly excel documents. Each document contains a sheet for each day of the month. Each sheet contains the same layout with data in different locations on each sheet.

I have managed to transform the data as required although this is a rather time consuming process as there are 30 or 31 sheets per document by 12 documents.

Is there a was to apply the same transformation to each sheet and load all sheets within a document.

Thank you for any help offered.

[Gysbert_Wassenaar]

Perhaps this document helps: Loading Multiple Excel Sheets Dynamically along with file name and sheet name‌

If not try searching for some discussion about loading multiple sheets from multiple excel files: https://community.qlik.com/search.jspa?q=excel+sheets+multiple