Hey, that works pretty good, thanks, some things I'd like to change

-Instead of specifying the originating sheet name, can the code just work from the 'active sheet'?
-Instead of specifying the destination sheet in the same workbook, can it auto create a new workbook
-Can you format the 'new workbook' sheet in the same format as 'originating workbook' sheet