Sum formula to get overall results from different worksheets..

[asyamonique]

Hello,
Is there any easy way to alter the below formula, which will be more dinamic?
Cos I'm having big head ache if the row number changes for column A datas!
Many thanks.

=SUM(JANUARY!G5+'FEBRUARY '!G5+MARCH!G5+'APRIL '!G5+'MAY '!G5+'JUNE '!G5+'JULY '!G5+'AUGUST '!G5+'SEPTEMBER '!G5+OCTOBER!G5+NOVEMBER!G5+'DECEMBER '!G5

 

[asyamonique]

Hi,
Yes I've tried your formula and it works if the row numbers change.

=SUMPRODUCT(SUMIF(INDIRECT("'"&$A$5:$A$16&"'!b5:b1000"),D5,INDIRECT("'"&$A$5:$A$16&"'!g5:g1000")))

So far I'm using above formula cos column D data's has the unique ref# which are related with every worksheets column B data's!
Thanks again.