Enter a new name in the Name Conflict dialog box
 

I am not able to copy multiple worksheets from one workbook to and other.
When copying multiple worksheets, I get the following warning:

"A formula or sheet you want to move or copy contains the name 'arrrrrrrgh'
which already exists on the destination worksheet. Do you want to use this
version of the name?

To use the name as defined in the destination sheet, click Yes.

To reName the range referred to in the formula or worksheet, click No, and
enter a new name in the Name Conflict dialog box."

I must either accept the name, or enter a replacement name, to escape the
dialog box.

Any ideas, anyone?