If I read your request correctly, you want an exact copy of a Worksheet to a
new Tab/Worksheet. If so try this;

On the original sheet, in A1 Ctrl A , Ctrl C, open a new Tab/Worksheet
& Ctrl V.

Bob

"Robert M" wrote:

How do I copy / duplicate a worksheet within a workbook without having to
reconfirm all the cell names each time I copy the sheet over?

My worksheet has some 27 cell names & I may copy the sheet over many times
within the workbook - thus spending a lot of time pressing "Enter" to accept
the default.

Please advise / Thanks