Linking 6 Spread Sheets

I need to find out how I can link 6 spread sheets to a new spread sheet that will have totals on it. I want to be able to link the total sheet to give totals for each cell that corresponds to it on the other 6 sheets. The current way for putting =sum( and then individually clicking each cell on the other sheets is very time consuming and makes getting the totals take forever. I tried to drag the formula to the other cells and instead of automatically changing them, it kept the same exact formula meaning I had the same total in all cells.

How can I easily do this without having to individually do each formula??