EDIT to include the essential information from the link, original answer here at bottom.
The first two methods do not solve my problem, as cells referred to in formula continue to update the reference as extra records are added from the form. Method 3 answers my problem as specified in the question....
Method 1: Duplicate the sheet. Click on the little arrow on the tab and choose duplicate. This allows you to change the data, move columns, write formulas, delete data you didn’t want, etc… without messing up the original data.
Method 2: Link to the “Form Responses” information on another tab. If you create another tab and put =’Form Responses’!A1 into the new sheet, what is in cell A1 from the form responses tab will show up.
For me linking the sheets never worked. I saw either errors such "Google failed to link these sheets". Seems to be a user authentication problem. I don't understand why I need to link sheets in the same spreadsheet, seems to be an oversight on Googles.
Method 3: Use =importrange(“spreadsheet key”,”tab range”) in cell A1 on the new empty sheet, where spreadsheetkey is the long number in the URL. It will look something like this:
Use the extra range (e.g.3000)to accommodate new answers as they come in.
For me, this method is now working.
The answer seems to be here
I am having trouble with method 2 linking the sheets. Google access is denied between sheets in the same spreadsheet! Anyway solved in method 3.