When I want to use a list from a separate tab in Excel for drop down choices
I'm not able to Ctrl / Page Down to another tab in the excel workbook to
select the list choices. I have to manually type in the location of the data
in the "Source" box.

Am I doing anything wrong?