Export Revit schedules into one Excel spreadsheet and separate sheets/tabs

Take a look at this thread:

ScheduleView.Export supports csv, tsv etc which in turn only support single sheets. The alternative is to use Bimorph nodes to get the data from the schedules and then export to Excel