multiple sheet sorting

[justinhebb]

Hello all, I'm wondering if this is possible:

I have a spreadsheet with multiple sheets. The first is a master job
list, with a job name column, etc, and then i have 14 other pages that
link from that master job list and have more info in subsequent
columns.

What i'm wondering is if I can do somethins so that when I resort the
master job list (either because of adding a new job or deleting old
jobs, then can i get the rest of the data on the other 14 sheets to
follow those jobs around?

Let me know if I need to clarify what I'm trying to do...Thanks!

 

[Dave Peterson]

It sounds like it would be quite messy.

I really like to keep all my data in one spot/worksheet. Then I can use
data|sort or data|filter|autofilter to see the data the way I want.

 

[justinhebb]

Yes, if it was up to me, I may try that but I am making this
spreadsheet for others who are not very computer literate to use and I
need to make it very easy for them. Any suggestions anyone?