Vba macro check and add records from working file to other workbooks

Hi Expert,

I have a requierements to check, validate and add records from workbook to another workbook. Hop3 you can help me on my requirements.

here is the concept or process. i have 3 workbooks

1. working file workbook with macro codes that perform all the process.

2. called incoming workbook that contains all incoming data given by group that handle the incoming materials its a fresh data. 3. status summary workbook this is coming from other group that contains records monitor if it is already transacted in the system. the status column that contains Done and Not yet.

My requirements is

1. how could i the check the data from workingfile workbook if that particular tracking#, model, total and labels is exist in Status summary workbook. if exist i have to validate if the status is "Not yet" have to change the status at working file workbook as INTRANSIT" while if the status is "Done" change it with "RECIEVED".

2. the incoming data will be dump to working file workbook at the last empty row. before that i have to check if the tracking number is already exist to working file, if exist nothing will happen but if not yet exist i have to dump those tracking no and others details to working file workbook.

3. the same process with number 1 to check the records if exist and validate the status. if done or not yet.

Hoping the requirements is clear and well defined. Thank you very much.

By the way, just created a sample data for these 3 workbook into one workbook under 3 worksheet as reference.

attached is a sample data.