Excel formula or macro required

each day a large csv file is extracted from our system. It contains a variety of info each department requires to do their daily work. in my case i have written two macros to sort/filter the csv based on what info i require and then run a second macro to extract the columns of data i need into a worksheet.

this new worksheet contains color codings and notes regarding ongoing files which i have to keep as i use it daily.

Since this csv file is updated daily I need a way to determine if their have been any additions to the csv file that are my responsibility and incorporate them into my "ongoing" workshhett with the codings and notes.

since i can distill the csv file with my macros into the data i need, the remaining part of the puzzle is comparing the "working" sheet as it exists today with the updated csv file produced tomorrow and adding and highlight anything new while keeping my notes and color.

Thank you

i have real data available but i am hesitant to send it out onto the web. i can send you my macros.

i run the sort first and then then thee extract