Modeling Question - Retrieve calculations from calculation tabs
I'm in a relatively new role that's requiring me to build larger financial models based on historical data. I'm trying to incorporate the common model structure of:
raw data tabs --->calculations/Transformation tabs---->Summary/output tabs
My question is: On my Summary/Output tabs, I need to retrieve the calculations. What's the best way to retrieve these? Currently, I'm doing Index/Match on the vertical categories and horizontal dates to return the correct value. Is this the best way or is there a better way?