I have 37 worksheets with 11 x 10 columns of data.

Each worksheet represents one product and the data is the test results for
the product.

I need to be able to have a chart on a worksheet that will adjust itself
based on filtered data from each product.

In other words, I only want to see the filtered data from each of the
worksheets I am drawing from.

Where should I start? Is this doable?

Thanks
Holly