You can use the “Excel command” action (formerly “Excel metadata”) to obtain a list of sheets in the workbook. Then use iterations to load each sheet and save it in a separate file.
Check out also this topic: Multiple files, small variation in sheet name, import with parameter