Is there any way to make the items in the multi select boxes to also appear in the cells to the right of that box (individually)? Only 2 to 3 will appear at any given time in cell B36 based on what their contract has and when they are selected the worksheet will open that corresponds with the selection. When i select an "incentive type" it opens up the correct worksheet, but when selecting an "incentive area" cell B51 the worksheet previously selected disappears? When we select an "incentive area" that should not have any thing to do with the worksheet should be hidden or not. I just want to be able to put just one selection into the corresponding worksheet when it is selected. I have tried vlookup and an if statement but neither seem to get me the results that i am looking for. I have attached a sample file any help or advice would be much appreciated.