I am brand new to Excel macros. I have an Excel file that has emails saved as objects in worksheet 1. I want to copy emails that contain a specific word in the file name and paste those into a different worksheet. In the below example, I want the Mesa email to be copied into the Mesa worksheet and the Glenwood email into the Glenwood worksheet. Any help would be appreciated.

\1