Remove rows based on duplicates in certain columns, and merge data from another column

Hi,

I'm new to VBA...

In the example attached, I would like to run a macro so that whenever there's duplicate data in column A(approved Date), C(Total number of attendees), and E(full expense dollars) - I need them to be based on Header titles, not Column names in the VBA script -the macro will remove the duplicated rows and only keep one, and merge the data(employee names) from column D before removing the duplicate rows.

Can anyone help please.

Thank you very much.