Sensitivity Analysis with multiple worksheets and button to update

Hello everyone, I am new to the forum, and I was wondering if you could help me with a problem.
I am currently doing and internship in a company, and I have to integrate a sensitivity analysis on a fairly long and complex excel spreadsheet. I am attaching an example that i'm sure will make it easier to understand, but I shall explain thoroughly nonetheless.
I want to analyze how the variation of different variables, impacts the profitability of the exercise. For this, the profitability indexes used are NPV, and IIR.
The example contains 3 worksheets, which are as follows:
Data: Example worksheet that condenses information of many other worksheets, but only works as reference for other calculations. I added this sheet to represent how the other sheets communicate with each other.
Proforma: This is the main worksheet, on which I want to analyze the variation of said variables. These variables are highlighted in orange color, but as well as the Data Table, information in here may only be changed for example purposes, and must remain the same AFTER working on the sensitivity analysis.
Analysis: This is the main worksheet in which I want to do the sensitivity analysis. As an example, I only added 2 (4) tables, but the idea is the same for all variables that I want to analyze.

The objective is to analyze percentage changes on different variables, for example: ticket price, amount of visitors, restaurant concessions, etc. This percentage change is applied to the Proforma worksheet, which in turn varies the profitability indexes at the end. After this, I want to retrieve said indexes, and input them on the corresponding cell in the "Analysis" worksheet, to have the data corresponding how NPV and IIR varies depending on these percentage variations. The cells with gray highlight are just numbers, so that you can have an example of NPV and IIR variations. The idea is that these numbers are updated in relation with the sensitivity analysis for each variable, and also the process has to be easily repeated, so I want to integrate a button that re-applies the analysis, that way if I want to manually change data, I can redo the sensitivity analysis and understand how the profitability varies. Ideally this would be a single button for all analysis, but if that is too complex I can also work with 1 button for each variable analysis.

Nuances: 1. The Proforma worksheet must stay the same regardless of how many times the analysis is applied. This sheet may be shown to clients, and it has to represent actual data and not be influenced in any way.
2. Ticket prices or attendance is different for High-mid-low, but the percentage variation is applied evenly on each one.

I tried using Data Tables, but in the case of attendance or ticket prices, I have more than 2 variables so I cant use them correctly.

If you need more information, I would be happy to give more details or explain more about the problem. Also, if it is not clear on my profile, I am currently using Microsoft Excel 2010.

Thanks to all of you for your time and disposition, and I hope this problem has not been tackled before, but I cant be certain.