I have 100++ workbooks saved in the same folder. Each workbook has only 1
sheet. How can I combine all of them together into one big workbook without
opening each file and copy and paste? In that big workbook I just need to put
data from each small workbook one after another, no matter they are of the
same format or not.
Each small workbook has some merged cells, but in the new big workbook,
those cells should be unmerged.
Is there a fast way to accomplish this task?
Thank you!