VBA custom format adjustment

Hi,

The current attached VBA generates an e-mail per each Name from sheet "List" and attaches an xlsx in each e-mail with the associated data for that particular Name.

Can someone help by adjusting the code so the xlsx file attached in each e-mail will look exactly like "desired result.xlsx" attached in this post?

(the other functionalities of the VBA should remain the same)