Linking drop down to tabs

[jjmartinson]

Hey everyone, I have a workbook set-up with multiple tabs with data in the same layout. I have put together a master page with multiple drop downs for users to generate various scenarios. Due to the multiple drop downs, I have coded nested if statements in the cells that are to populate data. The problem that I have ran into is that I would try to link the initial drop down to a tab. Due to the number of tabs (7) and the number of drop downs (5), I cannot make nested if statements.

Would you all know how I could link a drop down to a tab so that the remained of the drop down options are tied only to the selected tab?

Thanks for looking.