copying and pasting from multiple reports without creating duplicates

i have a problem regarding copying and pasting records that aren't duplicates.

i get a raw data file everyday that is updated with information on current/new orders, which i import into a master sppreadsheet i've made so i can use pivot tables to manipulate it.

the problem arises when i want to create a report and i copy a bunch of records ive filtered down, onto a blank spreadsheet - if i import a new raw data file, with the same filters on the pivot table, and copy and paste another lot of records, it creates a duplicate of the record that was already copied over from a previous report.

how do i get it to copy across only new/updated records?

thanks

Doesnt matter, i found a superb solution on the cpearson website that highlights the last occurrence of a duplicate element in a list :

Another formula for Conditional Formatting will highlight only the last occurrence of a duplicate element in a list (or the element itself if it occurs only once).

=IF(COUNTIF($B$2:$B$11,B2)=1,TRUE,COUNTIF($B$2:B2,B2)=COUNTIF($B$2:$B$11,B2))

As you can see only the last occurrences of elements 'a', 'b', 'c', and 'f' are highlighted. Element 'd' is highlighted because it occurs only once. The occurrences of 'a', 'b', 'c' and 'f' that occurs before the last occurrence are not highlighted.

Sorted.