I have looked on the internet for a solution to simplify the following formula

=SUMIF(Clin1!E34,$A$1,Clin1!$W34:W35)+SUMIF(Clin2!E34,$A$1,Clin2!$W34:W35)+SUMIF(Clin3!E34,$A$1,Clin3!$W34:W35)+SUMIF(Clin4!E34,$A$1,Clin4!$W34:W35)+SUMIF(Clin5!E34,$A$1,Clin5!$W34:W35)+SUMIF(Clin6!E34,$A$1,Clin6!$W34:W35)+SUMIF(Clin7!E34,$A$1,Clin7!$W34:W35)+SUMIF(Clin8!E34,$A$1,Clin8!$W34:W35)+SUMIF(Clin9!E34,$A$1,Clin9!$W34:W35)+SUMIF(Clin10!E34,$A$1,Clin10!$W34:W35)+SUMIF(Clin11!E34,$A$1,Clin11!$W34:W35)+SUMIF(Clin12!E34,$A$1,Clin12!$W34:W35)+SUMIF(Clin13!E34,$A$1,Clin13!$W34:W35)+SUMIF(Clin14!E34,$A$1,Clin14!$W34:W35)+SUMIF(Clin15!E34,$A$1,Clin15!$W34:W35)+SUMIF(Clin16!E34,$A$1,Clin16!$W34:W35)+SUMIF(Clin17!E34,$A$1,Clin17!$W34:W35)+SUMIF(Clin18!E34,$A$1,Clin18!$W34:W35)+SUMIF(Clin19!E34,$A$1,Clin19!$W34:W35)+SUMIF(Clin20!E34,$A$1,Clin20!$W34:W35)+SUMIF(Clin21!E34,$A$1,Clin21!$W34:W35)+SUMIF(Clin22!E34,$A$1,Clin22!$W34:W35)+SUMIF(Clin22!E34,$A$1,Clin23!$W34:W35)+SUMIF(Clin24!E34,$A$1,Clin24!$W34:W35)+SUMIF(Clin25!E34,$A$1,Clin25!$W34:W35)

As you can it is just repeating across consecutive sheets. I have looked on the internet which has given me sumproduct and various things however I cannot get this working, can someone demonstrate how to convert my formula above into a simpler version?

Many Thanks in advance