Is it possible to pull list data from another worksheet within the
workbook? I tried doing this through Data Validation but error message
indicates this isn't allowed.

The problem with having the dropdown data in the same worksheet is that
the users are inserting and deleting the same same rows that contain
the dropdown data.