I'm helping my wife create a more automated workbook for tracking loans.

I need to perform what I think should be fairly basic but I am no pro.

Basically I have setup a summary sheet (master sheet) that she works from in a workbook called "Client Status Log".

She exports an excel file from her loan system that shows any new loans that have come into her company. Once exported she basically saves over the same file every time she exports from her system. I'll call this Excel workbook "Pipeline report".

In the Client Status Log I have a Data tab that is connected to the Pipeline report. So every time she exports and saves over the last file ("Pipeline Report"), this DATA tab will refresh and show the latest data when she opens the "Client Status Log".

Here's my question. How do I write a Macro that searches column A in the DATA tab and if it finds a value that is not present in column A on the Master tab, it returns the row of data into a new row on the Master tab? She has some other items on the Master tab that she uses to track but we're trying to get new records over automatically so she doesn't have to copy and paste.

Thanks in advance for any help!!!