Dragging formula linked to diff sheets

I have multiple spreadsheets in the same workbook, with a "totals"
sheet. Each individual sheet is exactly the same except for the
business name. On the totals sheet I want to drag the whole line of
linked formulas down, then (quickly) change the reference portion to
the correct sheet. Is there a quicker way to do that besides selecting
the row and 'replacing' the sheet reference? When I do that, some will
not replace correctly, 'blowing up' the formula causing me to link each
cell's formula (12 columns across)from the 'totals' sheet back to the
individual company sheet.

--Thanks
Chrism

Take a look at
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Chrism" <[email protected]> wrote in message news:[email protected]...
> I have multiple spreadsheets in the same workbook, with a "totals"
> sheet. Each individual sheet is exactly the same except for the
> business name. On the totals sheet I want to drag the whole line of
> linked formulas down, then (quickly) change the reference portion to
> the correct sheet. Is there a quicker way to do that besides selecting
> the row and 'replacing' the sheet reference? When I do that, some will
> not replace correctly, 'blowing up' the formula causing me to link each
> cell's formula (12 columns across)from the 'totals' sheet back to the
> individual company sheet.
>
> --Thanks
> Chrism
>

Awesome: Thanks!