to update all sheets with a check using parameter of first sheet

[atksamy]

Hi,


I am having a workbook with a number of sheets. All The sheets have the id number as the first column . but the remainig column sdiffer in all sheets.
THe first sheet shas a column called status.
What I want to do is for each id number whose status is yes i wantto update all fields for that id number in all sheets to 77777.

hope iam clear.

regards
thiru