Filter Results Shown In Data Validation List

My earlier post on this subject did not yield me an answer, so I am trying again. Here is the link to that post “Add Filter To Cascading Combo Boxes”. I hope it's not bad practice to start a new post instead of continue the old one. If it is, then I hope someone merges these threads instead of deleting this one.

This time instead of posting my real spreadsheet, I am posting a much simpler example, hoping for a better response.

Please download the attached example spreadsheet. On the workbook “Main” you will see cell “D2” is highlighted in yellow. That combo box (based on a data validation list) shows all the divisions that can be chosen. If you go to the workbook “CSI” you will see a sample of the data that I am working with. Each row of data that starts with a “00” is in Division 00, and each row that stars with “01” is in Division 01, etc.

Once a division is chosen in cell “D2”, then cell F2 looks up a named range. Then the green cells (D6 through D15) are limited to only those items that fall within the division that is chosen in cell “D2” by use of the data validation formula “=INDIRIECT($F$2)”

I am looking for a way to filter the results of these second combo boxes (data validation lists D6-D15) further. Instead of showing all the results of the named range which is shown in cell “F2” I would like it filtered. The filter would be based on whether or not the last column of data for any given row has a “1” in it. It doesn't have to be a "1", I'll accept any way that you can make this work. I am just using a "1" for this example. Whether or not a row contains a "1" in column "J" will change from time to time, and I am thinking that this will be an easy way to indicate, or flag, whether or not a row is "Preferred", but I'm open to other suggestions.

If the cell in that row, row “J” on worksheet “CSI”, contains a “1” then I would like it to be displayed in the data validation lists in cells D6 through D15. If the cell for that row of data is blank then I do not want it to show up in the data validation list combo box.

To complicate this further, I would like a way to easily switch this filter on and off. I imagine this would filter would be turned on or off based on what is selected in an option button group (like I’ve got highlighted in blue in cell “D4”, whose results are tied to cell F4), or through an additional combo box or data validation list.

I'm pretty stuck from moving forward on this project until I get over this hurdle, so I appreciate and help you can provide.

Thanks, Spence