I want to link text cells from one worksheet into the next empty cell
in another worksheet. i.e I cannot paste link to cell? because it may
already be full with a previous link.

Put another way. I want to automatically produce a list of names and
values from several worksheets into another worksheet without
overiding the previous entry to that 2nd worksheet. I want to
automatically add that data to the next available empty row in the 2nd
worksheet.

How do I do it?