Excel Macro: Filter Emails Fast

I have several Excel workbooks of 150,000 + rows containing names, job titles and email addresses. I need a VBA macro that can comb through the Job Title column, spot rows whose titles match a set of keywords that I will provide, copy those rows (or just the email addresses—your guidance is welcome) into a brand-new worksheet, and leave the source data untouched.

Key requirements
• Source files are always in native Excel format, so you can rely on worksheets, ranges and tables rather than import code.
• The solution must handle both a one-click manual run (e.g., a ribbon button) and an automatic mode that fires when a file is opened or dropped into a folder.
• Performance matters: even on 150k rows the scan and copy should feel snappy, so efficient looping, arrays or AdvancedFilter are preferred over cell-by-cell processing.
• I should be able to edit the keyword list myself—ideally in a hidden sheet, a named range or an external text file—without touching the code.
• The macro must create the new sheet (or new workbook if that is cleaner) on each run, name it with a time-stamp, and write out only the filtered records.
• Clear comments in the code plus a short read-me so I can maintain it later.

Deliverables
1. A fully commented .xlsm file containing the working macro.
2. Brief setup notes explaining how to add or change keywords and how to toggle between automatic and manual execution.
3. A quick demo run showing it on a sample dataset of at least 150,000 rows (dummy data is fine).

The sooner you can hand me a clean, modular VBA routine, the sooner I can start parsing these large lists. Let me know your approach and any questions you have.