Excel validation lists avoid blanks and errors with TOCOL(ignore) plus FILTER; the spill range stays stable across worksheets ...
I, someone with no prior programming experience, was able to build a custom website in no time.