In reply to Lianbo.

Not exactly, but you can generate a list of sheets (tables) easily:

/* Where XL is the name of the library you assigned. */
proc sql noprint;
select catt('xl."',memname,'"n') into :sheets separated by ' '
from sashelp.vtable where libname="XL";
quit;
data all;
set &sheets.;
run;