Excel data analysis

I have a lot of excel file generate everyday and name with date number. All the file are in the same data sheet type and the name are in the similar with all of them have a character with “_”. I want someone help me to write a vba program help me to read all of the file and generate one excel as a report as the demo I post.