You can have a list on another worksheet, you simply have to name that list:

Open the spreadsheet where your list is

Then - INSERT, NAME, DEFINE

Name your list- say - Horse

click in REFERS TO, then select the range of cells that contain your list.

Now, where you want your drop down box, click:

DATA, DATA VALIDATION, LIST - Click on source and type - =Horse

Thats it

Harry