Combining Linked Cells While Retaining Formatting

I need some quick assistance.

In the attached (On Sheet 1) I am trying to retain formatting of the cells being concantenated in column L. I am using linked data in cells, A, B, C, D, and E. Formatting as text is not an option. Later I will need to combin all of these contantenated rows into another concantenated space.

I am sure there is a macro that would simplify this but at this time I have a very minimal VBA knowledge.

The ultimate result in this instance would result in a field that would populate like this - F 5/26 5.71E, L 5/28 10.08E, L 5/29 12.17E

This data will later be used to populate a description field that is limited to 180 Char.