I need to be able to auto-fill a cell from a list on another sheet. First, is
this possible? Second, How do I do it? The second sheet has 30 some columns
each with 2 to 8 selections under a specific header. Under the same header
name on the primary sheet I would like to be able to select one choice from
each column. Hope I made that clear enough to comprehend my question.

Thanks.