I am creating a data entry page in which I want to use data validation Lists
to select the product that I want to enter. How ever each cell may be
different from the one above. For example in (c4) I want to enter pipe data.
I have a sheet named pipe as the source for this entry. In (c5) I want to
enter valve data or maybe pipe data or ell data. How can I use Excel to
create a drop down list that lets me decide which source page I want to use
and then go to it for me to make my selection?