I have a workbook with 7 sheets. sheet 1 is a summary and sheet 2 to sheet 6
are detail. The detail sheets have 6 sections in seven columns. Each section
is summed.At the moment I use a formula like this, =sum(first:lastD5) which
works. However if a row is added in any of the detail sheets the summary
sheet is incorrect. Can I use a 3D system with range names? Or is there a
better way to solve this problem?