There is no shortage of Windows customization tools, but this one stands out by giving you maximum control with the right methods.
Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets.