Macro to fill the data into Summary sheet basis of different scenarios from Data sheet

Dear Experts,

I usually exports my outlook email details in Excel but basis of that excel I need to create a summary sheet.

I need help in creating a Macro for it as the data in excel is very huge.

In excel file there are 2 sheets. First sheet name is “Data” in which the all required email details from Outlook is being fetched.

Second sheet name is “Summary”. In this sheet there are below two separate category fixed formats present:

Category 1 = “L1 (New) emails”
Category 2 = “L1 (Existing), L2 (Existing) emails”

In this sheet I have to fill Sender Name against User Name basis of Status, Type and Level details from “Data” sheet in the above defined category.

For ex: If any email is marked as L1, New and Info then the sender name will get copied to in Summary sheet column B against that user name (mentioned in Column D in Data sheet) and if any email is marked as L1, New and Comp then the sender name will get copied to in Summary sheet column D against that user name (mentioned in Column D in Data sheet).

I have attached a sample file for having more clarification.

Thanks,