What formula would I use for this process:

I'm putting this formula in cell B2 of worksheet 1.
First: take the number that has been entered in cell A2 of worksheet 1
Second: Search through worksheets 3-24 and find that number (the number will
be unique through out the worksheets being searched)
Third: Display the name of the worksheet it was found in.

I'm hoping this is possible without using VBA. If it is going to need VBA
please bare with me since I have never used it.

Thank You For The Help!