Excel 2007 : Reference multiple sheets

Is there a quick way to duplicate sheet references without out changing cell location?

For example, I have Sheet 1, with 175 cells of data that is linked to a "summary sheet" using the =/enter option. These cells are not incremental, there are skipped cells on sheet one that is not linked.

OK so I have 14 other sheets with identical format and I need to put this identical "link" per sheet into the summary sheet. If I take the summary sheet with the first sheet manually linked up and try to drag/copy/paste type of duplication it moves the cell reference instead of sheet reference.

Is there any way to mass move/copy sheet reference only? (other than manualy =/enter method)

So row 1 references sheet one all the way across
row 2 references identical cells but from sheet 2 all the way across etc.


What I had tried to do was copy all of row one, into row two but it changes cell reference incrementally and there is no way I can see to just change sheet reference.

Thanks in advance. I hope I made my request/problem clear.

Maybe this is easier to explain,
ON the summary sheet I want each row to reference the same cells all the way across but from different sheets, so row 1 references cells sheet1 row 2 references same cells on sheet2