Update multiple workbooks

Hello!

I need to update multiple workbooks.

I change a "constant" variables that is linked to multiple pricing workbooks. Each one of these workbooks sends a cell value out, which is dependent on the constant variable.

Is there a way to update each of these workbooks after I change the constant?

Thanks,

Ian

Do I need to use a macro for this?