how to copy sheets to another workbook using vba?
['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.']