Is there a way I can have it write into a separate worksheet on the same workbook as the input file ($excel)
yes. Spreadsheet::WriteExcel See method: add_worksheet()

Ps. If you haven't already, bookmark search.cpan.org