Creatiing various "what/if" scenarios
 

I have a file with numerous tabs (potentially up to 50), each representing the financial profile for a particular project. I also have a summary tab within this file where I consolidated all the projects so that I can see the financial picture for my entire portfolio.

Here is my dilemma....I have been asked if I can build in some logic (check boxes possibly on a user form?) so that someone could pull up my file and select the particular projects they would like to see consolidated instead of all the projects. I could easily do this manually by keeping a master file and then deleting the tabs that I do not want in my consolidation but I'm looking for an automated option.

Essentially, I am trying to create a file where we could do what/if scenarios based on various combinations of potential projects. I am drawing a blank on the best approach to accomplish this task.

Any thoughts would be greatly appreciated.

Regards,
HJ