Combine excel workbooks from multiple folder into one workbook

[linalin_Sd]

I am trying to figure out a method to combine multiple excel workbooks from different folders into one worksheet in one folder.

example:

	workbook1	workbook2	work book3	workbook4	workbook5
person1	folder1\p1.xlsx	folder2\p1.xlsx	folder3\p1.xlsx	folder4\p1.xlsx	folder5\p1.xlsx
person2	folder1\p2.xlsx	folder2\p2.xlsx	folder3\p2.xlsx	folder4\p2.xlsx	folder5\p2.xlsx

....for about 100 of these persons.

I want to combine all of the worksheet for person1 into one worksheet. Is there any way to do this?
Alternative is if there is way to print out all the files for person1 first then next person..... it will also work. Thanks for any suggestion.

[linalin_Sd]

In addition, some of the exist files may not exist.