Is there a way to duplicate a worksheet to another workbook, not the current one? I know I can duplicate a workbook and remove what I don't need, but my use case is merging a couple of worksheets from different workbooks into a single workbook, is there anyway to achieve this?