Hi all,

I'm looking for a code to loop through all opened workbooks and look whether there's a worksheet called wkly. sum.. If such a sheet exists, I would like it to be copied to a new workbook and rename the sheet to the name of the workbook from which it was copied from. If for example 3 workbooks contain a sheet named wkly. sum., I would like them all to be in one workbook at the end (not 3 workbooks).

I hope I made myself clear :-)

Thanks in advance