VBA Coding - Excel 2007

I actually have it set up as you've describe already. The VLOOKUP function is referencing a value the "Formulas" sheet, not the actual formula itself.
But, the formula on "Formulas" still requires values from the "Mod Calcs" sheet and these values are variable (they can come from different rows).
Therefore, I can't use a specific cell, or range, in the formula. The formula requires data from the row on the "Mod Calcs" sheet that is using the VLOOKUP function.

It's kind of a cycle that is using both sheets and referencing variable values on both, but without creating a "self reference formula"