How do I link all worksheets so that a chg in one will change all

[MarciaPhx]

Excel 2007: I need to have about 6 worksheets, all the same data, but all
sorted differently & need to reference them often. How to I link all 6 so
that any changes to one will change them all? Note this is in Office 2007.

 

[Sheeloo]

If you have your data in Sheet1 then go to Sheet1 Cell A1
and type
=Sheet1!A1 and copy down and across till you get all your data as in Sheet1

You can then select the whole of Sheet2 and copy in Sheet3, 4,...

You can then sort your sheets as you please...