excel nerds enter

I don’t know how you can do it across multiple files but on multiple “sheets” it would be something like

=SUM(E8:L8,Sheet2!D4:M4,Sheet3!E6:N6)