Copy data from many files into 1

I have 6500 different excel files with no matching organization within the files. I need them all to be merged into 1 excel file with proper database organization. I have attached a sample zip. The file "all contacts master" is where all the work should be copied to. The "notes" cell is an issue because there are numerous lines in the files that need to all go into 1 cell instead of many (unless you have a better idea but it needs to be easy to add more notes to and adding a column for each note won't be good.)