Goeie Middag Henk Stander,
Instead of creating a new Workbook and wanting to Copy and Paste, let us try it this way round.
First of all, you will have to go to Tools>Macro>Security - Trusted Publishers and check Trust access to Visual Basic Editor before running the attached sample Workbook.
After clicking on the Button, a Save File As screen will appear where you may enter the new Workbook name.
NOTE: Be careful here, because if you don't enter a different name, the actual active Workbook you are working with will be replaced, with some Sheets lost, and stripped of all VBA Code!
See if you can make do with this, otherwise we shall have to consider other alternatives.
Baie dankie,
Regards
Bookmarks