Maybe.........
1] Table 1 "Vehicle No"
1.1] In K6, formula copy across and down :
=IFERROR(INDEX('DATA ENTRY'!$C$4:$DV$21,MATCH($K$3,'DATA ENTRY'!$B$4:$B$21,0),MATCH($J6,'DATA ENTRY'!$C$2:$DV$2,0)+(COLUMN(A1)-2)+1),"")
2] Table 2 "DRIVER"
2.1] In Q6, formula copy across to R6, T6 and all copy down :
=IFERROR(INDEX('DATA ENTRY'!$C$4:$DV$21,MATCH($Q$3,INDEX('DATA ENTRY'!$C$4:$DV$21,0,MATCH(1,INDEX(($P$3='DATA ENTRY'!$C$3:$DV$3)*($P6='DATA ENTRY'!$C$2:$DV$2),0),0)),0),MATCH(1,INDEX(($P$3='DATA ENTRY'!$C$3:$DV$3)*($P6='DATA ENTRY'!$C$2:$DV$2),0),0)+MATCH(Q$5,{"PARTY","VEH STATUS","DRIVER","REVENUE"},0)-3),"")
2.2] In S6, formula copy down :
=IFERROR(INDEX('DATA ENTRY'!$B$4:$B$21,MATCH($Q$3,INDEX('DATA ENTRY'!$C$4:$DV$21,0,MATCH(1,INDEX(($P$3='DATA ENTRY'!$C$3:$DV$3)*($P6='DATA ENTRY'!$C$2:$DV$2),0),0)),0)),"")
3] Table 3 "PARTY"
3.1] In W6, formula copy down :
=IFERROR(INDEX('DATA ENTRY'!$B$4:$B$21,MATCH($W$3,INDEX('DATA ENTRY'!$C$4:$DV$21,0,MATCH(1,INDEX(($V$3='DATA ENTRY'!$C$3:$DV$3)*($V6='DATA ENTRY'!$C$2:$DV$2),0),0)),0)),"")
3.2] In X6, formula copy across to Y6, Z6 and all copy down :
=IFERROR(INDEX('DATA ENTRY'!$C$4:$DV$21,MATCH($W$3,INDEX('DATA ENTRY'!$C$4:$DV$21,0,MATCH(1,INDEX(($V$3='DATA ENTRY'!$C$3:$DV$3)*($V6='DATA ENTRY'!$C$2:$DV$2),0),0)),0),MATCH(1,INDEX(($V$3='DATA ENTRY'!$C$3:$DV$3)*($V6='DATA ENTRY'!$C$2:$DV$2),0),0)+MATCH(X$5,{"VEH STATUS","DRIVER","REVENUE"},0)),"")
Regards
Bosco