Combining Excel Files

OK, I have 100 odd excel files (will eventually have 113) all of which containing just one sheet-all named 'sheet 1' in their respective files. What I would like to do is combine these files into one mother-of-all excel files!
* Firstly, is this possible?
* If so, what would be the best way to do so? There is only A:H columns of data, amount of row data varies for each file.


Secondly, is there a way to auto-name the tabs?

Finally, (this is not an excel question but I'll ask anyway) in windows explorer, is there a way to get a list either in word or notepad or whatever of all the files in a specific folder? The 100 odd excel fines are in one folder and I woul like a list of their file names, if possible.

Cheers!