Multiple lists

[Emo]

I am making a large inventory list that I want to have available in a couple of sorted ways. One will be sorted by location, one by item, and one by category. Once this is accomplished I would like a sheet for each list, what I can't seem to do is; how do I make it so if I make a change in one list it will also change the other 2 lists???

 

[JE McGimpsey]

I am making a large inventory list that I want to have available in a couple
of sorted ways. One will be sorted by location, one by item, and one by
category. Once this is accomplished I would like a sheet for each list, what
I can't seem to do is; how do I make it so if I make a change in one list it
will also change the other 2 lists???

First, is there any reason that you *need* to have multiple lists? In
general, that's a recipe for eventual data corruption.

One alternative would be to apply AutoFilter (Data/Filter/AutoFilter...)
and use the header dropdowns to sort on that header when you want to see
that sorted view.