VBA - VLOOKUP Multi criteria

Hello everybody,

I have a problem, I can't find the right method to consolidate my table. I need to search instance with 3 criteria.
I join this one to simplify the explication.

Thanks you in advance for your support

I found how to consolidate first row, but now I have just a new problem to loop this script...

So in sheet "PROD" each 11 rows, we have a new table with another item. I would like to loop this script each 11 rows

I have got a idea ?

'--------------------------------------------------------------------------------------------------------------------------
'Consolidation Hours
'-------------------------------------------------------------------------------------------------------------------------
     For Each Cel In Sheets("PROD").Range("A1:Q1")
        If Cel = Sheets("Matrice").Range("BJ1") Then C = Cel.Column: Exit For
    Next
    If C > 0 Then
        For Each Cel1 In Sheets("Matrice").Range("BK1:BT1")
            For Each Cel In Sheets("PROD").Range("A2:A11")
                If Left(Cel, Len(Cel1)) = Cel1 Then L = Cel.Row: Exit For
            Next
            Sheets("Matrice").Cells(2, Cel1.Column) = Sheets("PROD").Cells(L, C)
        Next
    End If