try linking all cells to a series in the target worksheet then use the
CONCATENATE command

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a single
text item. The text items can be text strings, numbers, or single-cell
references.

Remarks

The "&" operator can be used instead of CONCATENATE to join text
items.

=CONCATENATE(E14," ",F14," ",G14," ",H14)


--
Tom Jung
------------------------------------------------------------------------
Tom Jung's Profile: http://www.excelforum.com/member.php...o&userid=28448
View this thread: http://www.excelforum.com/showthread...hreadid=480479