I dont know the exact syntax but I would point you in the direction of the for....each command. This will allow you to iterate through all of the files in the chosen folder. This should work as long as the sheets in each of the excel files are named the same.
If this doesn't help then I believe also doing a wildcard load (e.g *.xls) may help.
If this does help, then please mark my response as helpful and correct.
Thanks Mark but I just found the solution.
Do as explained in this page Loading Multiple Excel Sheets Dynamically along with file name and sheet name.
and disable the standard mode (http://help.qlik.com/sense/2.0/en-US/online/?_ga=1.188385836.504149128.1429862976#../Subsystems/Hub/Content/LoadData/dis…) to allow ODBC connections without libraries.