Hi everyone, I've only recently started using more advanced excel tools and I have come across a problem.

The workbook contains lists of tools and their locations within a workshop. I am trying to create a search box which allows a part number to be searched for and the location is shown. I've got it working so that if the data in a cell is text or number then it works. But the problem comes because the book has several sheets which are all compiled into one (where the search function needs to be), and the part numbers are referenced to other sheets, for example, '='F Left'!C23'
This is causing the search box to come up with no results, and I was wondering if there was a way to search across multiple sheets?

Thanks in advance,

Chris.