Consolidation of several Excel files and the addition of the source column

[rfeigel]

See if this helps.

Merge multiple CSVs into one and add the file name as column

I can merge CSVs now but my question is how do i add the source file name as a column on the consolidated file?