worksheet or Tab name : Summary

Cell C2 formula , Drag down and across

Formula: copy to clipboard
=SUM(SUMIF(INDIRECT("FName"&ROW($1:$5)&"!A:A"),$A2,INDIRECT("FName"&ROW($1:$5)&"!R1C",)))