find function over several worksheets

[snowsis]

I am setting up an Excel database of items stored in a freezer at my work. The freezer has several shelves, each shelf has several racks and each rack has several boxes and each box has multiple divisions. I plan to name each item and enter it's specific name and info along with it's place in the box into Excel. My current setup has one box per worksheet and this freezer has the capability of holding 500 boxes.
My question is: let's say a year from now I'm trying to locate a certain item on my database so I can get it out of the freezer. I have not been able to figure out how to use the "find" function such that it would look throughout multiple worksheets and tell me exactly where I would find that item.
Suggestions?
Thank you for your help!

 

[Ralajer]

The regular Ctrl+F "Find" can search the whole workbook. You just have to click on the "Options" button and change the "Within:" box to "Workbook". Pressing find will take you the item.

Or were you looking for function so you can use it in a formula?

 

[snowsis]

Thank you very much for your reply....that does it! I apologize for my ignorance. That was so simple I should have found it myself!
But thank you again!

 

[Ralajer]

No need to apologize. If you weren't ignorant about anything then you would know everything. Also welcome to the board.