Hello!

I`m new to this group so greetings for everybody :).

My questions (MS Excel 2007):

There are 10 separate files, each containing a similar worksheet. There
is an eleventh, cumulative file, containing a chart from these ten files.

The number of files grows constantly. I would like the charts in the
cumulative file to change, based on the newly created files. How to do
this in a possibly automatic manner?

For example: 5 persons are evaluated each month with a 10-question test
and get a grade (from 1 to 5)for each question. In the cumulative file
there is a chart depicting the mean grade for each person and each
question, calculated from previous evaluation charts. I would like the
cumulative chart to change with the creation of each new evaluation
chart, which is placed in the same folder.

Thanks in advance
Peter