To anchor cells in a Google spreadsheet so that you can drag the values/cells/formula, with one or more of the linked cells/values remaining constant you can follow these steps: http://productforums.google.com/forum/#!topic/docs/zFm4W8t3CR4
But how to do it for many rows and columns?
I'm using data from Google Forms in a spreadsheet and every time someone makes a new input, formulas on another sheet change.