I am having trouble organising a large database of names that needs to be
updated from old database. Both workbooks were created in 2003 Excel
Professional Suite.

How do I import the new names from the other workbook? This needs to be
either collected somehow and placed in another workbook or into the same
workbook onto another worksheet.