sum and transfer corrsponding data from sheet to other according to product name

Dear All
First i would like to genetrate number in Column E in sheet1 with formula
that will do the following
look to column A and Column D
if the cell in column A contain same name ( like in A2,3,4 ) will look to column D if the same also like (13/05 in D2,3,4)
will give value in E 1 and rest give zero Like E2,3,4
another example will find in A5,A6, A7,A8 whcih contain Sample value but you will find D5 is differ from D6,D7,D8
for this it give D5 value 1 and D6 value 1 but D7,8 value zero because its the same

second in Refer Sheet
in column G:I that Sum of Data from Column D:F look for Column A And B column
if the column A & B conatin the same value like in my example (A2:A7) and B2:B7 will sum Data correspomnding to this from column
D and put in G in the first row and E in column H and F in I column also in the first row



third in sheet1
look to the data in E column if contain 1 copy data corresping from refer sheet (G:I column ) (please not to Column B lk or Fi data
to column G:I in sheet 1

fourth in sheet 1
look to the data in F column if contain 1 copy data corresping from refer sheet (G:I column ) (please not to Column B lk or Fi data
to Column J:L in sheet 1


hope my explanation is clear

Dear Ankur Shukla
its work good
but what about other data in sheet1 Column G:L
third in sheet1
look to the data in E column if contain 1 copy data corresping from refer sheet (G:I column ) (please not to Column B lk or Fi data
to column G:I in sheet 1

fourth in sheet 1
look to the data in F column if contain 1 copy data corresping from refer sheet (G:I column ) (please not to Column B lk or Fi data
to Column J:L in sheet 1

please check my new file
that conatin error in sheet1 in each G6 is missed data because E6 contain 1
also In H7,H8 conatin data although E7,8 contain 0

thanks its work good now

please ceheck because i found other incorrect value
K14 M15 in sheet1 must be 41 0 2 like G:I in refer sheet

you will find it with red shadow

very good its work now
thank you very much