Try this in B2, copied down...
=IFERROR(INDEX(Collected_data!$B$3:$B$35,MATCH(0,INDEX(COUNTIF($B$1:B1,Collected_data!$B$3:$B$35),0,0),0)),"")
And then in C2, copied down and across...
=INDEX(Collected_data!$B$2:$O$35,MATCH(Conso_Data!$B2,Collected_data!$B$2:$B$35,0),MATCH(Conso_Data!C$1,Collected_data!$B$2:$O$2,0))