Is there a way to search trough multiple worksheets for a specific value?
Other posts have mentioned to use VBA, but I have never used that before. If
anyone can give me some advice on using that or a type of formula to perform
that can search multiple worksheets.

Thank You