[quote=GTO]I would like to add a new worksheet to the original workbook (Workbook 1) that is housing the macro and combine all the data found in the selected files.[/QUOTE]

Quote Originally Posted by GTO
test2
test
Quote Originally Posted by Blue_Bunny
I would like to add a new worksheet to the original workbook (Workbook 1) that is housing the macro and combine all the data found in the selected files
That is just weird...