How to link data so it can be sorted by different parameters on multiple worksheets?

[MikeGBR]

Hi,

I'm trying to set up a spreadsheet of contacts' information with name, country, e-mail address columns and then have the data linked and sorted alphanumerically, by different parameters, on separate work sheet pages. ie Sheet 1 would display the contacts alphabetically by name; Sheet 2 would display the contacts alphabetically by country; Sheet 3 by e-mail address alphanumerically etc. The tricky bit is that I would like the data linked on each sheet, so that if I change or add data in any cell it would be reflected on all the sheets. Ideally, I would like the data on all the sheets to re-sort automatically, if necessary, with any change.

I thought that this would be a fairly common requirement but I cannot find instructions anywhere. Can anyone please help?

Thanks.

Mike

 

[RatExcel]

Just create pivot tables on each tab

 

[MikeGBR]

Just create pivot tables on each tab

Thank you for your suggestion. I didn't realise that I could do this with pivot tables. I shall investigate.

Regards

Mike