Cell A1 gets the value in E9 with =INDIRECT("E9")
Cell A2 gets the value in E9 with =E9

Now, what happens if row "6" is deleted?

Cell A1 still gets the value from E9 but cell A2 gets the value from E8.

INDIRECT(ref_text;[a1])
Returns the reference specified by a text string