Extract Invoice Information from Source Data Sheet to Individual Worksheets

I have a data Worksheet that holds invoice details based on a 'Code' in column A (see attached sample).

Each code then has its own tab in the Workbook. I'm trying to find a way to extract the invoice information from the 'Data' tab that relates to each 'Code' so it appears on the associated tab based on the code entry in cell C3.

I've completed the expected outcome for tabs AB123, AB124 and AB127 and provided the criteria on the Data tab. The idea being that when a 'Code' is entered in cell C3, it extracts the relevant date from the data tab as per the sample worksheets.

I have no idea if this is possible to achieve using formula or code but would welcome any help trying to find a solution. Please let me know if anything doesn't make sense.

Many thanks

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))

Hi Ford,

After a bit of trial and error I managed to get this working as needed, many thanks for your help, much appreciated...