Are you looking for there to be a relationship between the original and the
new copy in the shared workbook, where if you made a change to the worksheet
in the external location it would update the shared workbook and vice versa?
Or are you just trying to make a copy of a worksheet into another workbook?