Copy Worksheet from one open workbook to another...
 

The option to copy a worksheet from one open book to another isn't there.
Usually it gives you New Book, and lists any others you have open as an
option to copy to. The other open books don't show as open. Did I
accidentally turn something off, never had that happen before.
--
gp