Have two worksheets. On sheet 1 in cell D48 have the following formula:

=SUM((D9C9), (F9E9), (R9Q9), (Z9Y9), (AD9AC9), (AF9AE9), (AH9AG9),
(AN9AM9), (AP9AO9), (AR9AQ9), (AX9AW9), (BB9BA9), (BD9BC9), (BF9BE9),
(BN9BM9), (O3P3), (O4P4), (O10P10), (O14P14), (O16P16), (O17P17),
(O18P18), (O21P21), (O22P22), (O23P23), (O26P26), (O28P28), (O29P29),
(O30P30), (O34P34))

I would like to move it to a cell in sheet 2 but is there a way yo do this
quickly so I don't have to insert 'Sheet 1'! in front of every cell used in
the formula. It wouldn't be bad but I have to move about fifteen or so
formulas with various amount of variables (cells).