I need to create a chart from data contained in multiple worksheets (all in the same workbook). I am using Excel 2003. I need to chart a specific cell within each worksheet. It's the same cell in each worksheet, say B7. I have about 100 worksheets. So I need to be able to select all 100 worksheets and tell Excel to chart the progress of the B7 cell in each worksheet. Each worksheet contains data for one day and is named after the date/time of creation. So really the chart is to show the value of the B7 cell over 100 days.

Does that make sense? Can anyone help me to create this chart?

TIA,
Martin