Getting Unique Value, copy specific columns to another worksheet

I have been getting so much help from this forum. I am reaching out again to help with this small project. I have details that I would like to update unique data and copy specific columns to antoher worksheet. I have attched a test workbook. Again any help would be appreciated.
UNIQUET2.xlsm

Thanks David, i think i can modify this to get to do what i need