I may have read it, but I certainly didn't understand it.

If you mean, does the line disappear from the last sheet, if anyone changes D32 from Obradi to anything else, then yes, it will disappear from the list in the last sheet.

If you want the line to remain even if the user removes Obradi from a D32 cell, then no, it can't be done with normal Excel functions. You would need to rework all the above work using VBA macros....