You will need to use the Worksheet.Copy Invoke node and wire the Before or After input with a reference to a worksheet in another workbook.
If you are already accessing both workbooks, just create a reference to a sheet in the target workbook using the Workbook->Sheets Property and Sheets->Item Invoke nodes. Use Variant to Data to convert that variant into a _Worksheet reference.
Use a _Worksheet->Copy Invoke node with the source sheet as the input reference. Then wire the target reference into the Before or After input and you are done.
Michael
www.abcdefirm.com