Combine excel workbooks from multiple folder into one workbook
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.