Monkeyhop,
It sounds like you need an IF formula. In B10 of Sheet4, use something
like this:
=IF(Sheet1!B5="","",Sheet1!B5)
which says if B5 is blank, then return blank, Else show the result of
B5.
However you will need to change it to take account of B5 in the other
sheets. But I'm not sure what as you haven't said what you mean by 'get
info', e.g. Sum, Count, etc.
Hope this helps.
Clive


--
Clivey_UK
------------------------------------------------------------------------
Clivey_UK's Profile: http://www.excelforum.com/member.php...o&userid=32569
View this thread: http://www.excelforum.com/showthread...hreadid=537772