in reply to Copying Cells of an Excel Sheets
Take a look at Spreadsheet::ParseXLSX for reading in the data. Take a look at Excel::Writer::XLSX for how to extract macros and write new spreadsheets.