Copy formulas from one spreadsheet to another keeping the original sheet cell reference

I have a workbook in Excel 2003 with multiple worksheets, with each sheet for the most part representing each salesman. Off to the side I have a range of cells that have formulas that are based on that salesman's sales for the month. The formulas are used to compute a sales managers commission.

I want to move the range of cells from each salesman's individual spreadsheet to the manager's sheet, but in so doing I want the formulas to continue to reference the original cells in each salesman's sheets.

In other words, in Salesman 1's worksheet Cells U4:AB28 contain formulas based on data in Salesman 1's Cells A4:S28. Because each salesman can see his/her individual sheet and I don't want him/her to see the computation of the manager's commission I want to move the formulas in Salesman 1's cells U4:AB28 to the manager's sheet, but want the formulas after moving to continue to reference cells on Salesman 1's sheet.

Can I do that without doing extensive re-typing?

Thanks Ace_XL and K m.

I had gotten the formulas to the managers sheet and had considered the Find & Replace option, but because of too many salespersons and too many cells referenced I had decided that was going to take too long.

The idea of the white font and the protection for the cells could work, although I know my boss would still be concerned with someone stumbling upon the formulas at some point.

K m, your second suggestion of the separate workbook would probably work best - keeping the security of the calculation of the manager's commission from the salesman, and maybe more importantly from the other managers.

thanks again.