Use a macro to copy data from Outlook email to Excel workbook

[Santhoshhrishi]

Dear Team,

I am trying to create macro where I want to send excel attached on a monthly basis to new hires.

It is easy to capture data for 5/ 6 employees sending emails, but it becomes diffcult when 30+ team employees send me email and i need to copy paste data every time.

My Requirements :
1) A excel file which is uniquely [same format] wil be sent to employees to update the details & forward the sheet to me.
Once i receive emails from particular employee [Every subject line will be same change ] an excel file to run macro and copy information from each email sent by employees and I a particular master sheet

I have attached sample sheet which i require and visualization how i require. Team, would you pls help me in arriving at.

Regards
Santhosh

[Santhoshhrishi]

Team,

Please help me out in doing this.

Regards
Santhosh