Best way to lookup multiple Google Sheets?

I have a Google Sheet that has several sheets/tabs inside it.

I need to look up data, and depending on which sheet/tab the data is in, the automation continues to do different things.

Right now, I have an automation that works as follows:

Search sheet/tab #1 for the data. If data not found, router searches sheet/tab #3 for the data. If data not found, router searches sheet/tab #3 for the data. etc etc

I keep adding more sheets/tabs, and so this automation is getting longer and longer.

Is there a better way to do this? I would like to search all sheets/tabs inside of a google sheet, and depending on which sheet/tab the data is found it continues the automation in its own specific way.

Hey @fisto

You can use "Google Sheets: List Sheets" to check for the sheets inside the Spreadsheet.

I don't think that helps my solution. What do I do with the list of sheet names?

I would like to search all sheets in a Google Sheet, instead of having a Yes/No router for each sheet.

Hello? Can I get any assistance with this?

Hey @fisto !

You cannot lookup over multiple Google Sheets.

As of now, lookup can be used for individual sheets only.

For reference, you can check on the following video tutorial-

youtube.com/watch?v=_2zfrxZ4C-U

Hope, we have mentioned your query.