Insert rows in linked table that are added to secondary table
 

I hope that someone can help me make my life easier. I currently have a
excel file that I need to update on a weekly basis. Because I have multiple
charts that I run, one for each person and then a total, and because of the
way the powers that be want the individual chart, I needed to do things
differently than I am used to.

I needed to make a worksheet with all the data that would drive my charts.
Then I have a worksheet for each person and then a worksheet that has the
totals. Each of the worksheet breaks things up in a couple of sections (ie
pending and complete). The chart is at the top for that individual. The
problem is I would like to only enter the information in once on one sheet
and have it automatically update the others. I don't care if it is the
individual's page that I update and have the auto update happen to the
overall sheet or the other way around.

The formulas that I have tried either won't add an inserted field or they
require you to have extra rows. I can not do this in this workbook. I would
be happy to email a sample of what I am doing if that helps.

Thanks