Using the macro recorder, I came up with the following:
-------------------------------------------------
Sub Macro1()
'
Workbooks.Add
End Sub
-------------------------------------------------
Before doing this, though, define sourceWorkbook = activeworkbook.name,
and repeat for new workbook, so you can easily switch between them.
Resulting in:
Dim sourceWorkbook, destinationWorkbook As String
sourceWorkbook = ActiveWorkbook.Name
Workbooks.Add
destinationWorkbook = ActiveWorkbook.Name