I would like to write some code to take data from cell on one sheet and
put it in cells on a different sheet. The data is going across
columns, and I want it to rearrange into one column on a different
sheet. And also continue to be linked to the source sheet.

Reggie