Good Morning,

I have a macro that I have to run on approximately 200 workbooks all within
the same directory - after the macro completes on each worksheet, I need to
paste a certain range from each sheet to a new file and then close the file
and go to the next one in the directory.. At the end I'm looking to have all
of the copied ranges in one combined sheet.

Is this possible?