Hi John,

I have an idea. See the attached. I've been telling people Excel works best if all the data is in a big table instead of separate sheets or workbooks.

I copied your 3 data sheets to a single one. I then did an AutoFilter on the column A. Then used the Text Filter using CONTAINS what you want. Copy and paste what is left to a new sheet. Better yet is leave them in a single table and don't need separate sheets.