Data Transfer on the "to" flip "b" in Excel?

I put the formula to multiply (in this case) the number of guests present, and the price per plate. In another piece, I keep track of all costs involved in the case of keeping the budget withhin. As the answers come, I can A leaf update (which updates the total price). Is it possible to transfer to the "B" will also update the prices as well? When cut and paste the cell with the formula I get "REF" and nothing happens.

Type = SUM (Click any column in another worksheet) This will give a formula that looks like this: = SUM ([Book4] Sheet1 $ A: $ A) Be sure to click on every column, so add the rsvp comes in not creating a total will be double counting.

Broadway Meets Vegas Productions