As per my understanding MASTER sheet is being considered as parent sheet and rest of the sheets are being considered as child sheets. Additionally all the sheets names are in MASTER sheet as headers. Furthermore, You are validating the ClientCode from parent and child sheets and updating the value of Status Column in Parent sheet with value of Status column with Child Sheet.
You can make use of the code attached if my understanding is right. Else please share more details.
SebiReport.zip (11.0 KB)