All:

I have a financial model that is set up (generically) as assumptions tab, revenues tab, expenses tab, financial statements tab, etc.

The assumptions tab has a cell used as the scenario generator. User can put 1, 2 or 3 (downside, base, upside) scenarios.

The entire workbook refers back to this under many =IF(assumptions!$B$5=1,15%(IF($B$5=2,20%,30%)), etc... for the various scenarios..

Everything calculates properly and it is a very complex set of revenue/expenses done all the way through.

The problem -- I am being asked to add a final tab that just has the revenue and net income for ALL scenarios (even when the user doesn't change the 1 2 or 3 manually). That is, they want to see the revenues in 2014 under downside, base and upside scenarios on a separate worksheet. Any idea how to do this? I'm at my wits end.

I tired this scenario manager part of Excel, but it didn't work because there are many worksheets and this summary page must be on its own separate worksheet.

thx

-prophets