I have a workbook that contains 9 worksheets. The first worksheet contains
all of the sales data broken down by each of our warehouses. The other 8
worksheets shows a column chart for each of our 8 warehouses by month. When
I enter the next month sales information into worksheet 1, I have to go
through and update each worksheet following that one so it shows the next
month in the chart. I would like to be able to update the first worksheet
and all of the others follow automatically. Is this possible and do you have
any suggestions that would help make this more automatic rather than so
manual and time consuming?

As and example, this is somewhat what the first worksheet looks like:

2/5/2007 3/5/2007 4/2/2007 5/4/2007
Status RSC
9 1 $10 $10 $7 $2
8 1 $5 $9 $6 $2
8 1 $3 $8 $5 $3
7 1 $2 $7 $4 $3
6 1 $1 $6 $4 $2
$1 $1 $1 $1

There will be 8 different sections just like this repeating down the
spreadsheet and then the other tabs will be a column chart with each RSC on a
different worksheet.

Thanks!