I see what you're getting at. The unique data isn't all of what I need, though. The unique data would only be brand new entries. Any open entries from the previous day or report would be a duplicate now. However, if I simply pasted it all onto the main sheet and clumped duplicates together... I could manually sort and filter. Now I'm back to using up time just getting the spreadsheet updated, which is exactly what I don't want to do.

Is there a way then to take duplicate information and have certain columns overridden and others merged with a macro?