Duplicating rows across sheets

[oberon.black]

I am on the last leg of my project after this it is just working out a few more save option.

This portion is pure hell. I need a code that I can insert that will allow me to do the following.

What I need to do is get the information that is found in 'B10' and 'B11' of the 'CGS' worksheet to copy over to the client worksheets and then get all of the information that each client has on there row copied over to there worksheet.

example:
view from CGS
---------------------------------Date (B10)-----------Date (C10).............
---------------------------------Income (B11)--------Expense (C11).......
Smith, James (client)-------1,500 (B12)----------1,800 (C12)............
Johnson, Mark (client)------1450 (B13)----------1321 (C13).............


I would like for it to display as follows in (client worksheet)

Smith, James (worksheet)
Date (A12)-------Income (B12)----------------1500 (C12).........
Date (A13)-------Expense (B13)--------------1800 (C13)..........

Johnson,Mark (worksheet)
Date (A12)-------Income (B12)----------------1450 (C12).........
Date (A13)-------Expense (B13)--------------1321 (C13)..........

[oberon.black]

please take a look at this

[oberon.black]

just have alook

[oberon.black]

help please