How do you search through multiple sheets to find a specific value?

Thank you StephenR and Andrew-R. I have tested both sets of code and both work really well. Thanks for helping me out, I can now continue