Need help with gathering information on muliple sheets and work books on one sheet

Hi All
I need help with a summery of information of suppliers "A-D" in colm F. I need the sum of Supplier "A" info colm E in Sheet A-C combined in sheet 1 colm A and B.
Hope the info is clear
Regards

=SUMPRODUCT(SUMIF(INDIRECT("'"&sheetlist&"'!f3:f50"),A$2,INDIRECT("'"&sheetlist&"'!e3:e50")))

where sheetlist is the range name where it has sheet name(A,B,C...)

or use this formula if your file has few sheets
=SUMPRODUCT(SUMIF(INDIRECT("'"&{"A","B","C"}&"'!f3:f50"),A$2,INDIRECT("'"&{"A","B","C"}&"'!e3:e50")))