Charts/ Graphs information from more then one worksheet
 

Well I´m starting to get deeper and deeper into things that I do not
understand :) I have Excel worksheets for every month, each with the name of
the corresponding month. What I need to know is if its possible to take
information from all the worksheets of every month and put these into a chart
or graph so we could track the progress of a sertain person. to be more
specific.

Example of John
Month of May (May.xls)
Week1 (numbers)
John (#) (#) (#) (#) (all are in the same row as john)
Week2 (numbers)
Week3 "
Week4 "

Then we have
Month of June(June.xls)
and all the weeks

Is there a formula or a way to get all the information thats in his row from
every week of every month and put them into one chart to see the progress of
John? With the worksheets being seperated?

Any Help would be welcome!

Each Month is a different Wookbook.