Copying rows to separate worksheets based on data in one column.

[Shelby_McPike]

Can I get help making/finding a formula or process?

Sheet 1 is Client info A-Q columns and 1-600 rows.

Columns A, B, D, E, F, G and I need to be able to be viewed in sheets 2, 3, 4 ,and 5.

The information that should determine which sheet the information in those columns duplicates to is determined by four specific codes that are found in columns D, E, and F. 

The problem I'm running into- I can't figure out how to get the information to update on each sheet when one is edited. So if I change the status of information in sheet 2/column G, I want it to change the information in each sheet where column G's information was originally duplicated. 

Can anyone advise?

[#2]

My best advise is for you to attach your sample Excel file with detailed explanation of your goal.

[#3]

If it helps, 

The codes in D, E, and F are initials and sheets 2-5 are labeled by the initials. The data that needs to be duplicated from sheet 1 to the other sheets is based off of whose initials are in the columns D, E and F. @Shelby_McPike 

[#4]

Okay thank you

@Twifoo 

[#5]

If I were to ask, and you were to answer, to your own question, you will understand what I meant.