I have a Dir with many SubDir. I want to open the file in each SubDir
which has been modified last and copy Sheet(1) to a summary WB. Rename
each new sheet in the summary WB with the first 6 characters of the
SubDir. In turn, close each WB, after it has been copied and the
summary sheet renamed without saving it. The final result will be a
summary WB with 1 sheet for each project. Your help is very much
appreciated. TIA

Greg