The cells won't sort corectly with other worksheets linked

I have a problem!!!
First I have multiple worksheets in a workbook.
And in one column that has some names. and the columns next to them has data
which is yes/no go/ngo for each person.
If I add a person it will update itself in each worksheet. But I need to
sort it.
So I sort it and it sorts fine in the worksheet I'm working in. But with
the other worksheets it sorts it but the data for each person doesn't stay
with the person...
I hope I explained this problem to where someone can understand. PLEASE
HELP!!!

Boraguru,

It sounds like a selection problem. Maybe there are empty cells between the
columns. Take a look at "Sorting in Excel" at
http://www.smokeylake.com/excel/excel_truths.htm.
--
Earl Kiosterud
www.smokeylake.com

"boraguru" <boraguru@discussions.microsoft.com> wrote in message
news:267406C8-7FE1-41BD-957B-D0A446A92CDC@microsoft.com...
>I have a problem!!!
> First I have multiple worksheets in a workbook.
> And in one column that has some names. and the columns next to them has
> data
> which is yes/no go/ngo for each person.
> If I add a person it will update itself in each worksheet. But I need to
> sort it.
> So I sort it and it sorts fine in the worksheet I'm working in. But with
> the other worksheets it sorts it but the data for each person doesn't stay
> with the person...
> I hope I explained this problem to where someone can understand. PLEASE
> HELP!!!