Set a cell equal to the formula in another cell and not its value

Hi, I have the following issue: I have a file with numerous sheets with the same data columns (different data). The final column is a formula column using the actual sheet's data for the calculatio...