Connect values from sheets to a drop-down list

Originally Posted by davesexcel

I think I understand, You can use the Indirect Function, check out the attached.
Look at the yellow cells, select A11 for the drop down.

Note: oh, I see this has been discussed already.

You can still probably use the find replace function to edit the formulas, it might take some time but once done it's done.

Thanks, looks great will try it out. How did you get the drop-down list based on the sheets without adding an extra sheet with the names? (value1, value2)