Dear All,
How do I delete rows in worksheet1 containing hundreds of rows based on criteria as in worksheet reference as shown below. Until now I'm doing the deletion manually, which is very cumbersome.
Your guidance how to delete it using formula/program would be much appreciated.

WORKSHEET1 - before deletion based on criteria in Worksheet-Reference (text) . Column D is text others are date and numbers.
A B C D E F G
1 a1 b1 c1 d1 e1 f1
2 a2 b2 c2 d2 e2 f2
3 a3 b3 c3 d3 e3 f3
4 a4 b4 c4 d4 e4 f4
5 a5 b5 c5 d5 e5 f5
6 a6 b6 c6 d6 e6 f6
7 a7 b7 c7 d7 e7 f7
8 a8 b8 c8 d8 e8 f8
9 a9 b9 c9 d9 e9 f9
10 a10 b10 c10 d10 e10 f10


WORKSHEET reference (have data as in Worksheet1,column D)
A
1 c3
2 c5
3 c7
4 c8

AFter deletion
A B C D E F G
1 a3 b3 c3 d3 e3 f3
2 a5 b5 c5 d5 e5 f5
3 a7 b7 c7 d7 e7 f7
4 a8 b8 c8 d8 e8 f8

Thank you