Would a select, copy and paste do the task you want?
Select the sheet you want to copy
Click above row 1, this will highlight the whole sheet
Copy, go to the target workbook and paste on the Sheet1.

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"CWay" wrote:

I am trying select a specific worksheet from another open workbook, copy it
as the first tab in the active workbook.