Using data validation you can create a drop down list using information that
is already on a spreadsheet, however, when I try to get information from
sheet 2 or sheet 3 it will not allow me to click on the individual
worksheets. Is it possible to pull data from other worksheets to create a
drop down list on sheet 1? Thank you!