INDEX MATCH MATCH/OFFSET MATCH MATCH with named ranges

May be like this:

Formula on H1, copy down and to the right as far as you need

=INDEX(INDIRECT("'CP FFPAW'!A"&MATCH($B2,'CP FFPAW'!$A$1:$A18,0)+2&":F"&MATCH($B2,'CP FFPAW'!$A$1:$A18,0)+7),MATCH($D2,INDIRECT("'CP FFPAW'!A"&MATCH($B2,'CP FFPAW'!$A$1:$A18,0)+2&":A"&MATCH($B2,'CP FFPAW'!$A$1:$A18,0)+7),0),MATCH(H$1,INDIRECT("'CP FFPAW'!"&MATCH($B2,'CP FFPAW'!$A$1:$A18,0)+1&":"&MATCH($B2,'CP FFPAW'!$A$1:$A18,0)+1),0))