Formula in Forms for Excel updates automatically

Hi, 

I have a OneDrive Business Plan, which allows me to create Forms For Excel  in my OneDrive. 

I have created a form named "Training Request Form" using the Forms for Excel at a location in my OneDrive, and whenever someone fills out a response it automatically shows up there in a Sheet named Forms in Training Request Form, and this works fine. 

However, my form has branching questions, and specifically because of this I have created another Sheet in Training Request Form named:  Sheet 1.

In Sheet 1 I am fetching data from the Forms sheets and populating it using some formulae such that when a response is filled and the Form sheet is populated, it should automatically populate the adjacent Sheet 1.  I am doing this using some formulae. Initially about 6-7 responses were filled after which the requirement came that there should be a Sheet 1  in which the data from Forms should be filled (because of branching questions there are gaps and one has to scroll towards right to see data)

So I added the formula: =IF(ISBLANK(Form!E2),"",Form!E2) in my Sheet 1's Row 2 that as soon as data in E2 Row is filled specific information from there is copied in my Sheet 1, which works fine if the responses are already there. The problem arises in real time.

The Problem:

Initially when 6 responses were already filled, I used =IF(ISBLANK(Form!E2),"",Form!E2) in Sheet 1 and dragged the formula to be used in the whole of the Column. But when a response is filled the formula =IF(ISBLANK(Form!E7),"",Form!E7) [in Sheet 1]  is automatically changed to =IF(ISBLANK(Form!E8),"",Form!E8)

Am I missing something, or doing it wrongly? Any help or alternate solution would be helpful. I can give more info if this is not clear.