Stop your formulas from breaking by switching from grid-based coordinates (ROW) to stable table measurements (ROWS).
Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.