I would like to append and update excel master workbook with new and updated rows.

Hello All,
First, my purpose here is to have someone else write some VBA code for me that performs the task of taking data from one worksheet and copy to a master spreadsheet. This macro would be attached to a button on my master workbook and it would do 3 things only. 1 - Prompt for the name of the workbook within the worksheet that I wish to pull update data from. 2 - Perform a compare on a single column (#1) which contains a unique identifier and would then perform one of two functions. Update all columns of data(17 columns) from source to master in case where identifier exist in both. Append data starting at last used row in master workbook when identifier in source workbook does not exist in master workbook.
I only need help writing the VBA code for this.

Background: This spreadsheet contains a workbook called master which is initially populated with January monthly report data. There is also a workbook for each month which is populated with each months report data. The master is really the important workbook. The other workbooks will be just used to initially update master and then to just represent what was received by reporting entity.

I have no programming background but would like to become familiar with programming in excel. I was hoping some kind soul could give me the code so I could then analyze it and see how it is working in my case. I have searched but cannot seem to find a request similar to mine. I can provide a spreadsheet with dummy data if requested.

The current spreadsheet contains 13 workbooks, each workbook contains 17 columns. The first column is the unique identifier: Folder ID,Purchaser ID,EU,MRN PFX,MRN,Receipt DT,Completed DT,Sequence Number,Profile Number ,Team Name,Assigned Analyst,System,Incident Number,BSI,Problem Type,Reported By,Days Aged. The number of rows is variable but usually around 150.

The reason for the request is that each report has a variable number of FIDs that do not have certain fields populated because they are in a OPEN state and have not been CLOSED or contain a 'Completed Date'. Those are the rows that will show up in the following months report with that information populated because by that time they are usually closed. I hope this makes sense.
I would like help writing this code. The only macros I have are ones where I have had excel record what I do and I just do not see how to do that in this scenario.

I have figured out how to paste all data into master workbook and then sort FID by Descending and CompletedDT by Newest to oldest which essentially accomplishes the same thing. I would love to see how this could be done with a VBA macro however in a more elegant manner.

Thank you

That is awesome. TY very much. Is there a way for me to view the code you used so I can learn from that?

nvm. found it. Oye, I can definitely understand some of it but am going to have to get some learning materials on this. Thank you again for your help.