In one directory, I have 100 worksheets each with one workbook (Sheet1).
I want to copy every workbook from all 100 worksheets into one new worksheet.


Is this possible?
Thanks.

Yes
try http://www.rondebruin.nl/win/section3.htm
or
http://www.rondebruin.nl/win/addins/rdbmerge.htm

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you Pecoflyer.
It was helpful.

You're welcome

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post