Scope of my Issue:
I have been assigned the task to come up with a process for merging multiple Excel 2007 Workbooks into one singular sheet in one workbook. There are a few thousand separate files which need to be merged, and I really do not want to manually sort through them all.
Is there a utility available to perform this task while maintaining the entries' Column location and populating the workbook by Row with the various files? Pointers on creating a utility that could do this would also be appreciated.
Thanks in Advance,