Hi Evelyne

you mean on worksheet 1 you have
...........A
1.....mouse
2.....cat
3....dog

and on sheet 2 you have
..........A
1....rabbit
2....elephant
3....rat

do you want - sheet 1 to have
.........A
1...cat
2...dog
3...mouse

or sheet 1 to have
........A
1...cat
2...dog
3...elephant
???

if it's the first one, perform a sort on each sheet
if it's the second one, sort of combining the three sheets into one, sorting
them and then splitting them back to three sheets - the only way i know that
you can achieve this is to use a macro / code - is this an option that
you'ld consider?

Cheers
JulieD

"Evelyne" wrote in message
...
I have a workbook with 30 lines per worksheet. I need to be able to sort
the
data from each line below the headers from all three worksheets. Any
ideas?