When you've created an Excel sheet with multiple tabs, select a tab and click in the first field.
Now click on HOME --> Format as Table:
Another option in the menu appears.
Click on Table Design and enter a Table Name:
Based on each table name you can create a searchbox now:
In the first tab select the field that should make your search visible and enter:
Keep in mind that in the example we use the table names:=IFERROR(FILTER(VSTACK(EU;ASIAN;USA);ISNUMBER(SEARCH($B$2;VSTACK(EU;ASIAN;USA))));"No Value")
- EU
- ASIAN
- USA