How to export Subject details from Outlook to Excel

We have a routine activity of sending emails to requestors. And then copy the Case ID alone from the subject and paste it in an EXCEL sheet. I would like to know if there is any macro available to extract the subject details from the email to Excel.
Please advise.

Thank you.