Yes, I believe both can be addressed, but we need more details.
Where is the dropdown, on the sheet? Is it reference by Rowsource?
If the dropdown is created from data on the second sheet, it's just a matter of locating and retrieving the data.
Each record on one row?
Can you provide a sample? (use a service like Box.com)