List combinations VBA

[BarstoolProphet]

Sry if this might already been covered, but I am new here and was unable to find my solution here. Please help.

Attached is my simple worksheet and a VBA title Aisle working atm. But it crashes due to the results.

In short what I need is a vba written or the existing one edited so that I get what I need in my final results.

In said worksheet you will find 9 aisles that will have items placed in them. Only one item can be selected from each aisle. And it can not be repeated.

So for ex: If apples is selected from aisle 1 ,,it no longer can be selected at any time throughout the process.

Also I found that "duplicates" are occurring,,,which is making the total number of results exceed excel's limits,,and are not needed.

EX: If Milk is selected from Aisle 5 and then Cheese is selected from Aisle 6 ,,my VBA will also include Cheese from Aisle 5 and then select Milk from Aisle 6. This is redundant. I do not need that as an option.

So Milk,Cheese Is the same as Cheese,Milk,,in this example. if i could eliminate those "duplicates" I think that it might stop "crashing"

Thanks in advance for ur help.

Again if we need to write an entirely new vba ,,so be it..

Also I would like the results to be listed on new sheet rather than active sheet.

Thanks