I am loading multiple sheets with external data. I am going to load each set
of data into a different "List". I would like to use the List as a range in
other functions, ie use the Vlookup to scan the List.

Anyone familiar with how to set a Range equal to a List?