hi puttu. use this in B5:
=SUM('Qtr1:Qtr4'!B5)

in Data tab -> Consolidate, you could do that too. i don't really use it, but you can explore