Is it possible to copy a group of cell results with out pulling the formulas over to a new worksheet ?

what happens now is it copies the formulas with the =Sum(workbook!Formula) to new workbook, I would like only the result [443] not the formula pointing to another workbook - is this possible?