(='the Answers to the form (1)'!C1)tried to transfer the data from the worksheet with the answers on another sheet, then I simply pulled this formula across the table, but when the answer sheet appears as a new row, all the formulas change cell values below 1, i.e. if
(='the Answers to the form (1)'!C1), it became
(='the Answers to the form (1)'!C2). How to make these values did not change without the use of fixation of cells using "$" or how you can lock in 1000 cells at once with "$"?
=arrayformula(indirect("'Answers to the form (1)'!c1:c)"))