Creating a global search across all the tabs in spreadsheet

[Jeff_Hager]

Here is the thread you are talking about.

Global Search across multiple sheets

I have a pretty cool app for our sales rep firm, that has multiple sheets (using Google sheets) including inventory, pricelists backorder lists distributor invetory, etc… How do I create a global search across ALL the sheets that would have SKU or common name and return all the results on 1 page? Is there a way to link the sheets so they all get searched? Currently still using the older APPS version, and have not transitioned to My Projects

You just need to change the layout style to Detail and add an inline list for each table.