Help please - Excel pulling the wrong row through when I have copied formula down..?

 Hi All, 

I work for a small charity and am trying to set up systems but have hit a stumbling block in excel. 

I have an MS Form set up with responses going to an Excel online sheet. I need the responses to pull through to a second tab to be analysed. Sounds simple...

I have set up the second tab to pull through and analyse the data and all looks good. 

Here is the second tab. I have pulled the formula down from the top so that it +1 for each next row. It should therefore pull through the corresponding cell on the first tab.  

Here is the data on the first tab which is pulling through - as you can see this is working here. BUT...

When I get a new response to the MS Form, the second tab is adding a row to the formulas and so not pulling through the correct data. See the first tab cell F12 is populated with new data:

The formula for cell F12 On the second tab has mysteriously +1 to F13 and so the data is not pulling through? I can pull through the data by manually dragging it down but the problem is we need this to be automatically pulled through on to the second tab (as need to use it in an automated flow on Power Automate next) 

Does anyone have any ideas? Im really hoping it is a simple explanation! 

Thank you so much 🙂