I have a workbooks that has 3 worksheets.

I have taken the 3 worksheets and combined them into 1 (combined) worksheet
using formulas. They are all located in the same workbook. I now want to
export data from the combined worksheet so I need to seperate it from the
other 3. However, if I copy it the data is replaced with error messages
since I used a formula to obtain it from the other worksheets. Is there a
way to keep the information as it appears on the combined worksheet without
having it linked so that I can copy this worksheet to another location and
not get errors in the cells?


Thanks for your time!!