Sorry if my explanation of the problem is confusing:

I have a document with three worksheets. The first worksheet has a list of
contacts. The second worksheet also has a list of contacts, some of which are
the same people in the first worksheet. I need to copy the contacts that do
not appear in the first worksheet into the third worksheet.

Is there are formula/macro/filter that could figure this out? I need to work
it out today so I'd be grateful to know anything, even longer methods (eg.
could I paste all the information of the two sheets on to one worksheet and
do some sort of search that will display results that only appear once?)

Thanks for any help you may provide.

Georgie