trying to keep an updated workbook with excel reports?

Hello Everyone,

I am trying to keep an excel workbook with Active and Inactive employees.

I would like to update my Master Workbook with my Active Employee Report each week, adding the new employees to the bottom of the sheet or having them stand out in a way so that I can add additional data later on.

Next, I would like to move employees no longer on the Active Report to the inactive sheet within the Mater Workbook.

I am still learning my way around excel and all of my attempt to do this have been unsuccessful. If someone could give me an idea of how to pull this off it would be greatly appreciated.

I have attached an example of Mater file along with an Active report with dummy data.

ActiveEmployeeReport1.xlsx

Master1.xlsx