Hi,

I have a set of worksheets (about 20) each of which contains exactly the
same data, but for different products. I want to send this externally and
have a summary sheet so that someone can select a product name from a drop
down list and be presented with the data for that product, along with an
appropriate chart (rather than have to create 20 separate charts and get them
to click on worksheet tabs to see the data).

I know how to create drop-down lists, and how to create the chart I want,
but I don't know how to drag in the data correctly. Anyone help?

Thanks,

Andy