Macro to unhide sheets based on cell value (not sheet tab name but tab contents)

[HNoble]

Hi

I'm looking to see if there is a way to unhide sheets based on a cell value imputted on a main sheet, which then finds the cell value within other sheets that are hidden.

So I don't want to unhide the sheets based on their sheet tab name, but to find the cell value within the sheets to match and unhide them.

For example, the main sheet has a few search options (engineer name, project name etc.). Each sheet that is hidden has a table at the top of each page with this information. So if I was to enter the name Bob for the engineer, it would find every sheet that has Bob in the table and unhide them.

Hope that makes sense and that it's even possible.

Thanks in advance!

 

[HNoble]

Sorry I meant in any of the other sheets. It's all working fine now and doing what I need it to so all good, thanks!

 

[Michael M]

OK, glad to help...