Concatenate tables of all sheets dynamically Qlik Sense

[h2bi]

So i have an excel file with table in each sheet, each month we create a sheet with the month name and we use the same table layout to introduct data for that month, so i have January, February, Marsh data, i want to concatenate the tables in all the sheets dynamically into one because each month we add a new sheet so it must be dynamic

Any ideas?

January

February

Marsh

[anat]

FullTable:
LOAD * 
From [lib://path/*.xlsx]
(ooxml, embedded labels, table is [Table 1]);

or use below link 

https://community.qlik.com/t5/Member-Articles/Dynamically-Loading-Multiple-Excel-Files/ta-p/1479021

[marcus_sommer]

In addition to the link from @anat if the sheet-names are known or could be derived in some way - like the available months in regard to today() - you wouldn't mandatory need an odbc-load to fetch the available sheets, for example:

t: load rowno() as MonthNum autogenerate 1 while iterno() <= month(today());

for each sheet in fieldvaluelist('MonthNum')
   t: load * from Excel (ooxml, embedded labels, table is [$(sheet)]);
next