I have a spreadsheet to manage my clients. I fill a form and the responses are recorded in a mastersheet from where individual sheets for all clients get populated using script. Now I have another sheet where there is a list of all clients in column A and I want to copy value of h32 from each clients' individual sheet to this list sheet using a script and paste it in the column B next to the clients' name. I also need it to update the value of column b if it changes in the clients' sheet. I need it to ignore the other sheets with specific names like 'Outward' , 'Inward' and 'Payment Details' Sample spreadsheet attached. https://docs.google.com/spreadsheets/d/1NjWn_6ZfmkRLAJLf0zeBhuKlEP7vWRxOPCyFnRtTeVg/edit?usp=sharing
Do not know where to begin with.
