I do a lot of the same things and have the same issues. What I've done is
create a reference column off to the side with the data I want to include in
the drop-down menus, then hide the column at the end. If there's another
way, I'm all ears.



"Té" wrote:

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!