Find exact text in exact cell but on any sheet?

So the goal of this question is to be able to assign a variable name to a sheet which could have a varying name and be in a varying order in the workbook. The sheet I'm looking for will always have the word "Name" in A20. Is there anyway to search each worksheet for "Name" only in cell A20 and if it matches then I can assign a variable to that worksheet to use later in my code?

Thanks for the help

Originally Posted by kev_

Try this

In general module:

Please Login or Register  to view this content.

Perfect thank you!