How to do a VLOOKUP across all sheets in Google Sheets?

Question

Google Sheets

There is a table that contains the names ( all unique ) of products and a link to them. The titles are divided into sheets, but the structure of the tables that store the titles and links is always the same.

How to make a VLOOKUP search so that it goes through all the sheets and affects even those sheets that will be added later, after writing the formula?

Answer 1

Make a trigger in which the formula will be rewritten when the table changes . In the formula, you can get all the data and immediately do a VLOOKUP ()
Something like:

=arrayformula(i(A2:A="";"";впр(A2:A;{
Лист1!A:B;
Лист2!A:B;
Лист3!A:B
};0)))

Answer 2

If the total number of positions does not exceed the allowed number of rows per sheet, use the FLATTEN() function.
New sheets will still have to be manually added to the formula with the specified function.