Making a chart using data from different worksheets in a workbook.

I should have read a few more posts before I asked. Looks like the answer I
will need (I have not read it yet) is he

http://peltiertech.com/Excel/ChartsH...iffSheets.html

"Ezlpo" wrote:

I am trying to make a chart (line graph) that uses data from many different
worksheets.

The graph is being created to plot sales data week to week for many
different salespeople. Each week is its own worksheet.

There are around 70 sales people, but for the report I am only interested in
8-25 (but potentially all 70). Their names are listed in column A, but
because there are so many of them they are not always in the same row as they
were the week (read: worksheet) prior.

Now I know I can take the time to create a graph for each salesperson, but I
was hoping there would be an easier solution. I do not have crystal reports
(not that I would know how to use them) and I don't have any skill using the
Virtual Basic features (although I fear that for this I will need to learn
some).

Thank you in advance.