Search in Google sheet

Hello community. I developed an application that allows to search for values in a single Google sheet.

Only I would like to improve my app to create multiple sheets. I would like that when I type in my text field a value that is found in my Google sheet, that the application searches in which sheet this value is located, once it finds value, it displays this value there.

NB: this value is a value which when it is found, the application displays the other values found in the same line as this value sought.

Is it possible to improve my application in this way?

You can use a gviz query to do this: