AutoFilter all worksheets in a workbook

[MattNiiro]

Hi Everyone:

Is there a way to make an selection on one sheet in a workbook and cause all other worksheets in that workbook to have the same filter applied?

To hopefully clarify. I have a workbook with 4 worksheets. Each worksheet pulls a different set of data from a SQL DB. Column A is an ID field that links all of the talbes together. What I would like to do is make a selection on the Summary page, for example choose ID 2 and then have the other three worksheets autofilter on ID of 2 as well.

If anyone knows if this is doable, or if anyone has a better way of doing this please let me know.

Thank you in advance for your time and have a wonderful day.

[Jokacave]

MattNiiro
Try this workbook

[MattNiiro]

Jokacave:

That is perfect. Exactly what I was looking for. Now to reverse engineer what you did. :D

Thank you for your time and effot.