Validation list would work better if the list is in the same sheet, try by linking the original validation list somewhere where the sheet report is, make this list the validation one and then hide these cells, is not what you are asking for but it works....

C