How do I link sorted data to other workbook sheets?

[Cori]

I'm trying to create a workbook with the first sheet being a general list of
issues with assignment to different persons. The general list is set up as a
list that I can sort depending on the urgency of an issue, the person
assigned to the issue, etc. I would like to be able to create links to other
sheets within the workbook designated one to each person named as assignee in
the original issue list. How do I set it up so that when an issue is inputed
into the main sheet designated to A, the issue will automatically appear on
A's personal sheet?

 

[Max]

One play to try ..

In Sheet1
-------------
Assume the "master" table is in cols A and B
data from row2 down
(with the key column "Assignee" in col B), viz:

Issue Assignee
------- -------------
Issue1 Peter
Issue2 Joshua
Issue3 Lester
Issue4 Peter
Issue5 Lester
Issue6 Joshua
etc

List across in say, G1:I1
the Assignees: Peter, Joshua, Lester

Put in G2: =IF($B2="","",IF($B2=G$1,ROW(),""))

Copy G2 across to I2, then fill down by a safe "max"
number of rows that data is expected in cols A to B,
say, down to I200?

In a new sheet named: Peter
---------------------------------------
Let's reserve cell A1 for the Assignee name

Put in A1:
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,32)

(This'll extract the sheetname into A1.
But you need to save the file first.)

Put in A2: "List" (as a col header)

Put in A3:
=IF(ISERROR(MATCH(SMALL(INDIRECT("Sheet1!$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+
64)&":$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+64)),ROW(A1)),INDIRECT("Sheet1!$"&C
HAR(MATCH($A$1,Sheet1!$1:$1,0)+64)&":$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+64))
,0)),"",OFFSET(Sheet1!$B$1,MATCH(SMALL(INDIRECT("Sheet1!$"&CHAR(MATCH($A$1,S
heet1!$1:$1,0)+64)&":$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+64)),ROW(A1)),INDIRE
CT("Sheet1!$"&CHAR(MATCH($A$1,Sheet1!$1:$1,0)+64)&":$"&CHAR(MATCH($A$1,Sheet
1!$1:$1,0)+64)),0)-1,-COLUMN(A1)))

Note: You'd need to correct / restore the couple of inadvertent line wraps /
line breaks when you copy > paste the above formula into A3

Copy A3 down by as many rows as was done
in Sheet1's cols G:I, i.e. down to A200 thereabouts

You'll see that col A (in row3 down)
will auto-return the "filtered" rows from Sheet1
for the Assignee: Peter
i.e. for the sample data-set above, it'll appear as:

Peter
List
----
Issue1
Issue4

Now, just duplicate / make a copy of the sheet: Peter,
rename it as: Joshua
and you'll get the "filtered" rows for Joshua:

Joshua
List
----
Issue2
Issue6

Repeat the sheet duplicating and renaming
for: Lester and you'll get:

Lester
List
----
Issue3
Issue5

And so on ..

Issues entered to the assignees in Sheet1
will auto-appear in each assignee's "personal" sheet

Adapt / extend to suit