Consolidate all data of different excel documents automatically

I have a directory of 200+ excel files (all of them together its 20 MB), ordered in different subdirectories and different file names. All of the files have the same structure. I need to put them all in only one excel, and adding at the end of each register 2 more columns that would be "directory/subdirectory name" and "file name" so we can differentiate from which source, name came each register in the final excel.