Hi all: PC Excel 2003

I have a Summary sheet that lists a bunch of drug names in Column A. To the
right of that column is one big Chart (just one). Now what I'm looking for
is a way to create some kind of "hyperlink Macro" so that when I click on a
specific Drug name in Column A, the big chart on the right will show data for
that drug.

Remember this is a summary sheet. All the data for each drug is spread out
across multiple worksheets...to which i could easily create charts on each
one if I wanted to. But I don't want someone to go TO those worksheets. I
want them to remain on the Summary Sheet, click the desired drug in Column A,
and see the chart for that selected drug right there on the same summary
sheet.

Hope this makes sense. Can anyone help?
Joe