title: Google Sheets - Change data in a sheet depending on what cell is clicked
body: <p>I have a &quot;Main page&quot; in my spreadsheet that allows you to search for chemicals and returns some information on any match found within the source data. I want each result to have a link that the user can click that will open up a sheet with some more detailed information on the particular chemical clicked. Is this possible?</p>
  <p><a href="https://i.stack.imgur.com/QN1Qa.png" rel="nofollow noreferrer">Example - clicking F5 would link to another sheet that would fill in cell A1 with &quot;Carbon Monoxide&quot; but clicking F6 would instead fill in the cell with &quot;Nickel Carbonate&quot;</a></p>