Question: how to copy sheets to another workbook using vba?
Answer: C:\Users\XXX\Documents\Target_Book. xlsx should be changed to the actual path and name of the workbook from which you want to copy a sheet.
Sheet1 should be replaced with the name of the sheet you want to copy.