if you are ok with a macro then it is pretty straight forward to step
thru the 9 worksheets one by one looking for a number in the original
workbook.

let me know if you want to go that way.


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=376599