One more comment with respect to my last example in the previous comment. It would be possible to use the option embed_titles_once='yes' in that specific example.

However, if we want to keep several titles in the second worksheet, I'm not aware of a solution/workaround:
- one title for a first proc print and proc odstext
- one title for the second proc print and proc odstext.

ods excel file="c:\scratch\example2bis.xlsx";
ods excel options(embedded_titles='yes' sheet_name="Females" sheet_interval="none");

title 'Female 15';
proc print data=sashelp.class(where=(sex="F"));
run;
title;

proc odstext;
p "Data for Female Patients";
run;

ods excel options(sheet_name="Males" sheet_interval="now");

title 'Male (Age-Sex)';
proc print data=sashelp.class(where=(sex="M"));
var name age sex;
run;
title;

proc odstext;
p "Data for Male Patients (Age-Sex)";
run;

title 'Male (Height-Weight)';
proc print data=sashelp.class(where=(sex="M"));
var name height weight;
run;
title;

proc odstext;
p "Data for Male Patients (Height-Weight)";
run;

ods excel close;