Code in cell but need to do Alt-Enter and put more code

I am trying to accomplish the example below with multiple codes in one cell but an enter in between them. Probably just need the code to do the enter formatting and mix the code together but below is a rough example. Anything do that?

=sum(A1:A5) Alt+Enter
=sum(B1:B5) Alt+Enter
repeats couple times...

Basically the code will pull several lines from the data page and create an address in one cell (formatted correctly) to be copied by a macro that opens a label sheet for the user to paste from clipboard into the area they want to print to on an avery 5160 template.

User chooses what row to pull the data in from. I think I have that portion down depending on what route I go here.

Working on doing it all in VBA but my skills in VBA may not be decent enough. Trying to figure out how to set a cell as a value...