How to copy a row to another worksheet

In am maintaining a file in Excel 2007 in which I would like to copy rows containing specific data in a particular column from a master worksheet to a new worksheet.
For example;
If a data is maintained in sheet no 1, and if ABC name comes in Column D row 10, then the entire row should get copied to another worksheet names as ABC, and it should get copied whenever ABC name comes in the D column.