See Spreadsheet::WriteExcel and xlsmerge - Merge worksheets from different Excel files into one Workbook, which does something similar but not identical, because it concatenates everything into one worksheet instead of copying the worksheets into separate worksheets.