title: Update different sheets automatically when Google Form Response sheet updates
body: <p>I have a Google form which is linked to a sheet <strong>Form Response 1</strong>. Now I have different sheets (around 10 sheets) which I want to populate automatically when the <strong>Form Response 1</strong> receives any response.</p>
  
  <p>In <strong>Form Response 1</strong> sheet, I have column "Name". Now I want to gather data in different sheets with respect to "Name". Can someone post me the formula of how every sheet updates its data when <strong>Form Response 1</strong> updates any record.</p>