Copy worksheet from one book to open workbook

[Nev]

Hi there

I hope you can help. I want to copy a worksheet from one book to the
workbook that is already open.
Example - open closed book called Owner Rep and copy the single sheet in
that book called sheet1 to the open book and replace existing sheet1.

thanks

Nev

 

[Don Guillett]

xl2003
right click sheet tab>move or copy>create a copy>select a book