Very Simple Excel Workbook, Sheet Template, Info from one sheet to another

I would like the following functionality with this excel workbook. I will outline how its set up and what I would like it to do. I would like the sheets to look the same. There is a master sheet (Origin), and there will be additional sales rep sheets. Each rep will enter data on their individual sheet which will show up on the Master sheet. There will be a status drop down box, which should be default as “open”, and then the other 2 options will be “Archived”, and “Closed”. If the user chooses to drop down and select close or archive it will be removed from the sales rep and the master sheet and only be listed in the archive list. If the user goes to the archived or closed sheet and chooses to drop the status down and select open, it will go back into the sales rep and master sheets. So to summarize, If a sales rep enters data into their individual sheet (RB, BH, TSD), it will automatically show up in the master sheet (Origin) too. If they select from the status drop down Archived or Closed, it will place that line item on the corresponding sheet (Archived, Closed) If the user goes to the archived or closed sheet and chooses to drop the status down and select open, it will go back into the sales rep and master sheets. I also want to be able to add rep sheets, so I will need to know how to add additional sheets, and that the whole workbook will function the same way upon adding the addition sales rep sheets.