Dragging thousands of formulas

For a slightly different approach this in C2 of Community List sheet and copy across to L2.

Formula:

=INDEX('All Data'!$E$2:$I$3,MATCH($A2&"_"&RIGHT(C$1,8),'All Data'!$D$2:$D$3,0),MATCH(LEFT(C$1,FIND("^",SUBSTITUTE(C$1," ","^",2))-1),'All Data'!$E$1:$I$1,0))