Not sure that I completely understand your situation, but referencing cells on other sheets is as simple as:
=Sheet1!A1
Replace "Sheet1!" with whatever the actual sheet name is.
That may not be what you are after, so explain how you are attempting to reference the "drop down cell".
Bookmarks