It is possible to export data to an existing workbook as a new sheet.
This should do the trick, though I would test it on a workbook you don't mind losing first.
 denote where you need to fill in info.
libname xls [file path to excel workbook]; data xls.[new sheet name];set [data];run; libname xls clear;