How to update status columns

Hello,

I have excel file, as shown in image the ‘MASTER’ Is maine and others chil sheets.

In master sheets there are multiple headers as show and the same name of child sheets also as per headers its start form sebi csv.

Now first I’ll check first header of sevi csv of the status is pending then I’ll go at that headers sheet (child sheet) and there I’ll check client code from master sheet if it’s match then check status of theat specific current row. After once the specific client code row done tye of success or falled as pe this basis update on master sheet of status column.

@Karthik23
@prashant1603765
@yedukondaluaregala

Thanks