Your sheet does still not show what you want to achieve , only the result of my suggestion which is not what you need



Is it ??

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The last had both sheet1 and sheet2, I believed.
This time I am sending file, sheet1, which is the project from which I wish to extract (copy) cells and place (paste) them on another sheet thus creating a list of names, addresses, etc.

Thanks for hanging with me and you continued assistance. It seems that there MUST be a way.

Attached Files

test15.xlsx (13.9 KB, 11 views)