I want to transfer data from SHEET1 to SHEET2

Put this formula in A6, then copy down and across the table:

=INDEX(SHEET1!B:B, MATCH($I6, SHEET1!$D:$D, 0))


Format column E for dates afterward.

Thank you
But in the case of repeated subjects are not well-Optimized
Example
1 H1 English1 A 11/01/2000
2 H2 English2 B 12/01/2003
3 H3 English3 C 15/09/1998
4 H4 English4 F 14/05/2003
5 H5 English5 G 19/07/2006
6 H6 English6 H 18/04/2000
5 H10 English1 B 20/01/2000

Note the repetition of
1 H1 English1 A 11/01/2000
5 H10 English1 B 20/01/2000

Originally Posted by hesham63

Note the repetition of
1 H1 English1 A 11/01/2000
5 H10 English1 B 20/01/2000

Your sample wb does not:

1) include repetitions like that
2) demonstrate the results you want with repetitions like that.