See if you can adapt this apporach?

1. Add a helper column on data shaat and copy this down (I used H)
H2=A2&COUNTIF($A$2:A2,A2)

2. to pull in the data, put this in C8 copy down...
=INDEX(Data!$A:$G,MATCH($C$3&COUNTIF($B$8:B8,B8),Data!H:H,0),MATCH($B8,Data!$A$1:$G$1,0))