Each time that you are ready to add the new entries from the several sheets
to your single sheet, how are you going to distinquish and copy only the new
entries?

"Bookworm" wrote:

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?