What would be the equivalent in VBA code to the Right
click on the worksheet tab where you can then Copy the
sheet or sheets to another workbook (which in this case
would be a new one).

Can anyone help?

Many thanks
Jacqui