Selecting the different Range of cells based on values

Hi all,
consider the Excel sheet
A B C D
1 NAME CITY AGE CLASS
2 ALEX NEWYORK 20 D
3 JOHN DURBAN 20 A
4 PRINCE DELHI 20 V
5 AMY TOKYO 20 C
6 LUCY MOSCOW 20 W
7 CARA LONDON 20 E

here I need the VBA logic based on the following scenario

IF city = Newyork, i have to copy and paste
DURBAN 20 A
DELHI 20 V

IF city = Tokyo, i have to copy and paste
MOSCOW 20 W
LONDON 20 E

please give me VBA logic how to copy that cells dynamically based on values in cell and paste in another excel sheet

Thanks in Advance
@akilsyed