Follow below steps:
1.Create the dashboard with required sheets.
2. Add a parameter to the sheet that you want to search a value from, and then add a calculative field.
You can refer here for the same, https://www.edureka.co/community/42815/search-in-tableau
3. Now the sheet that has this parameter control can be used as a filter to display those fields in all the sheets of the dashboard.
Hope this helps you.