How do I create one XLSX file from multiple datasets

I'm stumbling here.  I have a SAS program that creates a final dataset and I use an ods excel proc report that creates a formatted spreadsheet.  I also have 11 other sas datasets under a libname in which I need to get added to this single excel file as well.  Now I understand the limitations of ods excel not being able to create separate sheets easily into one file.  

What I'm struggling with is how to do this, whether I need to loop through the historical datasets in one single ods statement that creates these datasets on separate tabs or what.

/* so my libname statement is */
libname sasdata "mypath" access=readonly';

/* Then I have my macro at the end to create the excel file: */
%macro createReport(utildt);

options missing=' ';
ODS LISTING CLOSE;

ODS PATH (prepend) STD.template99(READ) SASHELP.TEMPLMST(READ);
ODS ESCAPECHAR='^';

TITLE;

ods excel file = " &rptpath./&filenm..xlsx" style=stdXLSX

/* CRITERIA PAGE - first sheet; specifies criteria for report */

options (orientation='portrait'
                   sheet_name=Criteria"
                           );

proc report data=CritReport no windwos headline headskip spacing = 2 missing split='|';

column description;

define description /display "REPORT DESCRIPTION;

run;

/* REPORT SHEET - second sheet; actual report data in a formatted sheet */

TITLE;

ods excel style =stdXLSX
options (orientation='portrait'
                   sheet_name=&utildt."
                    );
proc report data=FINAL_&utildt. nowd headline headskip split='|';
columns
name id field3 field4 field5;
define name / "Name";
define id / "ID";
define field3 / "Field Three";
define field4 / "Field Four";
define field5 / "Field Five";
run;

ods Excel close
ods _all_close;
run;

%mend createReport;

%createReport(&rptdate);

Select allOpen in new window