Sorting multiple sheets at once

[warchalkprinces]

I have multiple sheets of data and column A in each sheet is the same.
I have entered the data for column A in text on the first sheet and th
remaining sheets reference column A of the first sheet. My problem i
that when I sort the first sheet by column A, then ONLY column
changes in the remaining sheets. I need the data associated with colum
A to be sorted in ALL sheets. For example:

Sheet 1:
NAME AGE HEIGHT
susie 23 5.4
debbie 26 5.1
pasquale 30 6
helen 21 5.5

Sheet 2:
NAME FAV COLOR
susie (=Sheet 1!A2) red
debbie(=Sheet1!A3) blue
pasquale green
helen purple

So, when I sort Sheet 1 by NAME, I also need Sheet 2 to be sorted b
Name (so that I can keep FAV COLOR associated with the right person).

Any help on this would be greatly appreciated. Thanks in advance

 

[Dave Peterson]

Instead of using formulas like =sheet1!a1, can you find a common (unique) value
between the worksheets.

Then you could enter the keys on each sheet and use =vlookup()'s to return the
other information.

 

[BrianB]

I think it will be much more efficient to put all your data into a
single table.

If you want to show separate lists it would be no problem because you
just use formulas similar to the one you already have in the
appropriate sheets.