Is there any way to get Excel to Autocomplete based on another sheet or
the entire Excel workbook?

I have a list that pulls from another worksheet and I would like for
the autocomplete to work!