I have 12 folders each with 2 or more worksheet with similar records in them. I want to automatically merge Column E, F, G, H together into one Worksheet as one file (i.e. From all worksheet in all separate folder into ONE Worksheet under heading E, F, G, H).

Also I want to create another Column D and Put the file name that corresponds to each data row So I can quickly tell which worksheet the data is from.

Any help will be appreciated. Thanks Much.