I think you are trying to copy a worksheet into a new workbook (split it). If that is the case, right click on the worksheet name and choose Move or Copy, tick Create a Copy and also choose New Workbook from the To Book dropdown list. You can then modify it and copy it back into the existing workbook using the same process after you have deleted the original worksheet.