Hi,

Have a try with following formula ...

=SUM('Jan 2:Dec 25'!A43)