How to have information auto input if cell = yes
 

I need to be able to enter information on one sheet in a workbook and set a
condition (ex: data in column 3 = yes) to determine if the information in
that row should be automatically transfered to other worksheets.