Hey leslie,

If you want to copy a sheet from one workbook to another workbook and
save the destination workbook, you can easily use the macro recorder.
Think this is how it should look like.

Sheets("Sheet1").Select
Sheets("Sheet1").Copy
Befo=Workbooks("destination.xls").Sheets(1)
wkbk.Close SaveChanges:=True
MsgBox ("DONE!")

Greetz