Transfer cell formula from one excel sheet to another.

Does anyone know how to transfer a formula from one excel sheet to another if its in the same file and if you make a change to the cell on one sheet, it will automatically update the cell on the other sheet?

Thank you.