Automate the merging of many excel files into one (only the first worksheet). This is only useful if each file is the same table format (same columns). This tool accepts any file that Excel can open as input.
The Merge Tool attempts to merge the contents of all excel files in a directory into a single file.
This tool expects that each workbook contains only a single table on the first worksheet, all other worksheets are ignored.
The data as the last column and be labled 'Category' based on the name of the file.
