Indirect reference

Dear

I am using the Excel file where you will find the link below.

the field classification Level 2 is changing based on the content of classification level 1 and same thing for Market sub segment which content will change based on market segment.

to realise this I am using data validation and list. the list referefs to another sheet and indirect reference.

This is working fine except when i delete a line in accounts worksheet, the reference to the right line is not working anymore.

exemple : classification Level 2 in line 6 is : =INDIRECT(Reference_Indirecte!$A6)

if I delete this line  (6) then the classification Level 2 in this line is : =INDIRECT(Reference_Indirecte!$A7)

while it should have been modified 

please support me on this issue.

https://schneiderelectric-my.sharepoint.com/personal/sesa353194_schneider-electric_com/_layouts/15/guestaccess.aspx?docid=19f7368569eb24eeeaa7f4b2a3b3f2a67&authkey=AUquMHxiMXg9Vpao1-QwB8s&expiration=2017-07-13T23%3a00%3a00.000Z