Filter single criteria across all worksheets and return values to a summary sheet

Hi,

Please help me with a VB code to Filter single criteria selected from a data validation list across all worksheets and return values to a summary sheet.All the sheets have same headers.
Attached a sample of this.

Thanks
Shreeja

Maybe:

Please Login or Register  to view this content.

its works well John.. thanks a lot...

You're welcome. Glad to help out and thanks for the feedback.