Link Cells

[NTB]

A1, B1, C1, D1, E1, I1, J1 & D3 all linked to L1 thru S1 perspectively
But when I copy the highted box and paste it, A4 automatically link to L4, as well as other fields.

Would you help me create a macro where excel automatically generate
the link A1 = L1, A4 = L2, A7 = L3 and other fields perspectively all the way til the end?

I hope it wasn't too confusing.

Thank you!