Hello,
I have many workbooks containing multiple worksheets ( in C:\Lists\). Now I want to put all worksheets from all workbooks in ( C:\Lists\) into one single worksheet in a new workbook (C:\Lists\newWB.xlsx). All the existing worksheets have the same structure(same column number) and the first row of all worksheets is also the same. When the worksheets are put into master sheet, the name of original worksheet should also be copied for each row in Col. O. Each row in master worksheet should contain name of original worksheet in Col. O, so that its origin is always understandable.
Thank you very much for each help.
Bookmarks