I have multiple sheets that make up a business model.

I want to run Base, Best and Worst case scenarios from a master data sheet with changing input cells and then have the results cell from a Profit and Loss sheet show in the summery.

The problem I am having at the moment is that when I run the summary table, each 'results' cell is the same and clearly not taking the changing cells into consideration.

In order to run this across multiple sheets I had to merge the scenarios from the Master Data sheet and I'm wondering, does this merge mean that the changing cells from the Master sheet are not reflected on the sheet with the results that I want to view in the Scenario Summary table?

I hope this makes sense - please let me know if not or if you have any questions!