Macro to apply a filter from one sheet (a master sheet) to all sheets in workbook

Hi,

I'm looking for a method to apply a specific filter to all sheets in a workbook. I've read quite a few posts, and tried various approaches but so far to no avail.

What I'm looking for is when filtering for instance as in the attachment on patient 10011001, that all of the patient data is returned on all relevant sheets. I want to assign a macro, but I'm not sure on how to apply it when filtering. Should there be a mastersheet to start the selection from or something?

The other problem is that the patient is not always in the same column and row in the heading, which makes it a bit more tricky.

Any guidance/help on solving this would be really appreciated.

Regards
Sean