Copying formulas between workbooks

[Zoomnbyu]

When you copy a formula within a workbook it updates the formula for a new
location, i.e. the cells change to account for the new location.

Is there a way to do this across workbooks? I have a consolidation workbook
that links across three other workbooks. Rather than manually editing each
formula is it possible to have the formula update itself when copied across
multiple other cells?

Thanks

Zoom