This tutorial shows you how to apply data validation using a list on a different sheet. It assumes you already know how to use data validation.

[youtube https://www.youtube.com/watch?v=tPaDFbWYEWY&hl=en&fs=1]