Question: how to copy all sheets in excel to another workbook using vba?
Answer: Press and hold Ctrl and select multiple sheets in your workbook. Run CopySelectedSheetsToNewWorkbooks macro.