Append data to excel

I need a macro for opening a file (User can select file), copy the data from the Sheet,
append it to the existing open workbook (workbook with the macro)in the way, the data that is already present gets deleted.
i.e the duplicate should be removed.