Can a macro automatically be executed by the changing of a cell value?

I have someone who is a master sheet of data. He wants to split this sheet
based on won/lost value in a cell. The data will be moved to a "Won" sheet
or "Lost" sheet based on that indication of won/lost cell value on master
sheet.

I suggested he may need a macro in order to avoid blank lines within the
Sheet(Won) or Sheet(Lost).

Thanks,
Les