is there a way to use an array or something similar to calculate a 3 variable
problem, so that different sheets can reference a formula on another sheet,
and come up with different values, without having multiple formulas?

something similar to 3D arrays?
i've been using the index function with 2 nested match functions, but that
only helps with 2 variables