I have 4 sheets in the same workbook that reference a sheet that will only change from time to time. It contains an inventory, with reference numbers. When I reference this sheet (using "=SOURCE!A1" "=SOURCE!A2" etc.) the data is not searchable when I hit CTRL+F and search for a reference number.

Is there another easy way to reference the information on my SOURCE sheet so that I can search it on any worksheet it is referenced on?

I hope this makes sense. I am pretty new to this whole aspect of Excel. Thanks for any help!