in reply to Spreadsheet::WriteExcel: How to change order of worksheets?

Do you know the names of the workbooks in advance so you can sort on that? You can store your worksheets in a hash so you can reference them properly later to addataand so on.
my %worksheets; foreach my $w (sort @ws_names_from somewhere){ $worksheets{$w} = $workbook->add_worksheet( $w ); }