When criteria is met in a column, check dup value in another column and copy row

Hello. I have a file attach. I need vba to search for the word with "new" in the address in column D then when found look for the matches of ages in adjacent column C. Copy the entire row in sheet2.

Example is in sheet2. New York with age 36 and all age of 36 will be copied. New Jersey with age 21 and all 21 will be copied and so on. Is it also possible that the "new" will be either in the front or end of the word when searching?

Not all the duplicate age in column C will be copied. Just need to check the criteria in column D first before getting the dups. Tia.