Populate & maintain client worksheets from a host worksheet

[RLCornish]

Does anyone have a suggestion how to go about populating and maintaining client ws's from a host, or master ws of data? The table below is what the master worksheet will look like and contain.

I need to figure out how to auto-populate / maintain:

• In a CS1 ws the details about Project 1 & Project 4
• In a CEO ws the details about Project 2
• In a AR3 ws the details about Project 4
• And so on

Known factors:

• New projects will be added as time goes on
• Tasks can be added or retired as time goes on
• Details on projects can change as it goes along and the client ws would need to be maintained based on host inputs
• The PROJECT column will always be merged
• The TASK LIST will never be merged
• Other columns may or may not be merged

PROJECT	TASK LIST	OUTCOME	SMART GOAL	METRIC	OWNER	EXEC
Project 1	TD1	WIN!	Be SMART	Do great	CS1, CS2, AR2	CEO
TD2
Project 2	TD1	WIN!	Be SMART	Do great	CEO	PRES
TD2
Project 3	TD1	WIN!	Be SMART	Do great	CS3	SCMGR
TD2
TD3
TD4
TD5
Project 4	TD1	WIN!	Be SMART	Do great	CS1, AR3, SC3	CSMGR
TD2
TD3
TD4
TD5
TD6
TD7
TD8
TD9
Project 5	TD1	WIN!	Be SMART	Do great	SCMGR	SCMGR, CSMGR
TD2
TD3
TD4
TD5
TD6
TD7
TD8
TD9
TD10
TD11
TD12
TD13
TD14

<colgroup><col><col><col><col span="3"><col></colgroup><tbody>
</tbody>

 

[RLCornish]

I don't know what happened to the table I inserted. I swear, I'm much more adept within Excel than I am this forum. Sorry about that. However, all the "TD's" are To-Do, i.e. TASKS and should be under that column.