Spreatsheets and search bar and click

hello. my google spreadsheet has between 3000-4000 chemical names. I want to do something that will redirect the raw materials to another page when the results are clicked by adding the google spreadsheet, not manually as above.can you help me

You could use RecyclerList extension to render such large data see [Guide] RecyclerList - Google Spreadsheet - Custom Search - How to Add/Delete/Update records

I want the chemical names to be one under the other, not side by side. Also, as in the photo above, the search bar will be searched. How should I write the code?