Append the Sheet data

Enter this formula into B2 of 'Combined'. Fill down and across to AH5.

=INDEX(INDIRECT("'"&"Sheet"&$A2&"'!b1:b53"),MATCH(B$1,INDIRECT("'"&"Sheet"&$A2&"'!a1:a53"),0))

I did not do a painstaking check of all the results, but what I did check all returns the correct data.

Does this help?