Dragging formula linked to diff sheets

[Chrism]

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

 

[David McRitchie]

Take a look at
http://www.mvps.org/dmcritchie/excel/buildtoc2.htm

 

[Chrism]

Awesome: Thanks!