Hi @elmauri,
I actually created a post yesterday detailing how I’ve hacked together a universal search bar. I use Airtable as a data source, and I haven’t tested it out with Google Sheets yet, but you might be able to get it to work with a little wrangling of your spreadsheets – dynamically creating links and linking sheets might be an issue.