Find Option across multiple sheets

Hi All,
I have attacehd one file where there are different sheets of three different procducts.
I need to find those data where values are coming below 50 (accross all sheets).

So is there any way out to find out value to mark a check across multiple sheets(Sample File is also attached for ref).

Hi vjharry,

I think you can do your problem with multiple consolidation ranges in a pivot table. Look at the next two sites to see how to do it.
http://www.contextures.com/xlPivot08.html
http://www.pivot-table.com/2010/07/1...in-excel-2007/