Re: loading multiple sheets from all xls files in a folder
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.