Copy row sheet-sheet skipping unqualified cells
 

Hello,
have one master sheet which 4 other worksheets draw info from.
Other sheets have formulas that decifer whether information is valid or not by
using search function. Each entry feeds in master sheets feeds a depended
sheet but what I want to eliminate the blank cells inbetween valid entrys on
the dependent sheets. Example:
if A1 sheet1 = red, pastes A1 sheet2
if B1 sheet1 = blue, pastes B1 sheet3
if C1 sheet1 = blue, pastes C1 sheet3
This leaves me with a blank entry cell A1 sheet 2.
Is there a simple way of adding to formula that will ignore blank cells and
pull the next valid entry in the row to cell A1 in sheet 2?

Thanks for any assistance. - Steve Dallas