I have pretty much the very same situation. Have a set of files that contain date extracted from our point of sale that I consolidate into one workbook The number of files varies but they are all in the same location and I use a command line prompt to copy all the files into one and then open it in Excel. All the files need to be in the same location, then open a command line prompt and change to the directory where the files are located. Then enter the following command prompt in order to copy all files into one (I assume that all of the files have a .csv extension, but it can be any and it will work): copy *.csv combined.csv.

The combined.csv can be any name, it is just the one I choose to use. Hope this helps a little.