This video shows how you can loop through a number of files and load data from each of them into QlikView. Exactly the same technique can be used to load data into Sense. Simply replace the path with a library name instead, for instance lib://SourceData/ExcelFiles.
Please note that this page has been flagged as a new blog post in error. If you have arrived here from AskQV, WordPress or Twitter expecting new content please accept my apologies. Rest assured there will be some new content soon!