Data sort excel 2003

[Guest]

I have 5 worksheets in 1 excel file.
All worksheets are near to the maximum available amount of rows.
I need to do a data sort of all 5 worksheets so that each sheet staring from
sheet 1 are in numerical order.
In other words, all the data fields in each worksheet are in order for that
1 particular worksheet but they are not in order starting from worksheet 1,
line 1.
Is there any way or sorting all 5 worksheets and then puting in strict order
starting from sheet1, line 1 through to sheet 5??

Thanks, John

 

[Guest]

sounds like a cut and paste job that could take some time and additional
sheets to me. Put each shet in order and then visually inspect them for the
lowest values, cut and paste them to another sheet.