The Data validation dropdown list appears to need the list of validation
data same work sheet. I would like to have my validation data on a
separate sheet.
Can this be done?

Bernie Simmonds