Insert cells in 3-D ranges

[kaptainmidnite]

I have a workbook for tracking my billing. In the Totals sheet, I have 3-D ranges to total all the billing per day across each sheet (client). When I insert rows to a particular client's sheet for a given day (to accommodate multiple billing items), the 3-D range does not update to include those rows like it would if I were to insert rows in a normal range. Is there any way to accomplish this without having to specifically write out each worksheet name in the total formula? (which will be a pain later on if I ever add or remove clients).

 

[kaptainmidnite]

I've found a reasonable workaround - using row 1 and 31 columns to display totals using standard ranges on each worksheet, then creating 3-D ranges on the Total sheet which reference those cells, which never move regardless of how many rows I have to use. Still, I'd be interested in other suggestions.