His Excel-lence also recommends this: https://www.youtube.com/watch?v=JxBg4sMusIg
The "real" answer is to use names and tables. That and generally not having data flying up down left and right.
Also, when you need names, it is a sign to reach for a proper programming enviroment like Delphi or Lazarus.
His Excel-lence also recommends this: https://www.youtube.com/watch?v=JxBg4sMusIg