Shee1
A1
New Referral

B1
11111

C1
Yes

D1
00/00/2020
----------------------------------------------------------------
Sheet2

A1
11111
B1
Yes
D1
00/00/2020

If A1 = New Referral, Copy B1,C1,D1 to Sheet2

can someone help me with this kind of formula?