I have a worksheet that is primarily to fill in information that is then distributed to multiple places on other worksheets.

One cell contains a drop down list.

If I try to reference that cell from another worksheet in the normal way it just wont let you choose that cell at all.

If I try to use the INDIRECT function - it allows you to reference the cell but returns a #Ref! error. I just want whatever text is chosen from the dropdown list to appear in the other cells on other worksheets. It seems like it should be very simple (and probably is) but I'm struggling with it.