I have a workbook where the front sheet is a display page and the three
sheets behind are reserved for data tables. What I want to do is have one
cell in the front page which is a drop down and selects names from one of the
tables on the other sheets. From there I can use Vlookup to populate the
info from the tables on the front page based on that name. The problem is I
can't seem to get this list of names from another sheet. Every time I try, I
get an error. How would I do this? thanks!