I think I've understood this correctly.
You've written this in the formulas section so Im assuming you want some form of formula answer.
Presumably you have something like this

A1 contains the value 2
A2 contains the value 3
A3 contains the formula =A1+A2.

You just want the formula in A3 copied across to another sheet, though this will probably change the result of that formula and possibly produce errors if the cells don't contain data.

As stated I doubt this is possible via a formula, you probably have to use VBA to identify which cells have formulas and which have values.

UPDATE: Check these out, I havent looked that closely.

Via a UDF
https://www.ozgrid.com/VBA/ExcelIsFormula.htm

Via Condtional Formatting
https://groups.google.com/forum/#!to...sc/a_Mj0s-Fns0
https://www.mrexcel.com/archive/date...ke-this-exist/