Yes, that would be the regular way and is wonderful. I have 25 other cells on that work sheet that plug into two other worksheets in various locations. But it will not work with the one cell that has a drop down list.

On one worksheet I have all my information for an order. I put all my data in that worksheet and then that data is used in all the other worksheets. The one pesky cell uses a dropdown list for the user to choose which text he/she needs for the order they are working on. That one cell will not work in the normal way and I was told you could get around it with the INDIRECT formula but it just returns the reference error.