how to show cells without its formula, only its result

Hello,

i have a workbook. in sheet 1, i have data.
in other sheets there are calculation formulas with countifs,etc which examines this data in Sheet1.
when i copy these data in Sheet2, Sheet3, ...... to Notepad and copy them back to these sheets, i m seeing them only as Results, without Formula.
this is what i want to do.
i want to write a code for making all these formulated data only as seen results without its formula.

please have a look to my attached file and u will understand easily.
how we can a write a code for this?