Paste values all cells in a region which refers to out of region
 

Hi,
Suppose I have a region N100 to Y200, now I would like to paste values all
the cells in the region which refers to the cell out of this region.
The requirement is I have prepared a cash flow where values are coming from
different sheets and workbooks. Also few formulas of sum, minus and
percentage refers in this particular region only. I have to send this sheet
to somebody wherein all formulas refering to this region should not be
changed while all other cells should be paste values.