ListFillRange Values Dependent On Another Selection With Values in Another Worksheet

Hi All,

In one worksheet, I have combobox1 where a value is selected, and combobox2 that needs to populate a list of values based on the selection of combobox1. I've seen other posts where this is possible were all the information is contained on the same worksheet. However, mine is not. The dynamic data for combobox2 is on a different sheet, in a table. I know this is easily fixed using a data validation list and indirect, but I like the aesthetics of the combobox better. Indirect does not seem to work in the ListFillRange field. I also tried putting a data validation list in the same sheet, and putting that in the ListFillRange field to no avail. Attached is my workbook. Basically, I'd like the Route combo box in the Schedule tab to only reflect the routes pertaining to the selected Customer in combobox 1.
Thanks in advance!

Luke

Feels good to solve ones own problem. I added a new name and in the refer to field, I put the indirect formula. Then the new name is put into the ListFillRange field. Yay me.