Pull list / dropdown data from another worksheet?

[Annabelle]

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.

 

[jonathan9560]

I think if you name the range to be indexed, then reference the named
range in the seperate worksheet where you are creating the dropdown.

 

[Dave Peterson]

Try putting your list on a different worksheet, name that range and use that
range for the list.

Debra Dalgleish has some notes at:
http://www.contextures.com/xlDataVal01.html