Very Simple Access Database - Very Easy Project!

I need to have a very simple access database made. I will be uploading it and hosting it on Sharepoint, so it must be created in newest version of Access. I had an excel version of what I need done. So here are the requirements... I have sales reps who need to add items they have for sale to their list. Those items need to show in their list(Page), and also on a master list (Page). Each item will have a drop down box field which will make it so when they select a different choice it will move the item to another list called Archived, or Closed (2 Separate lists(pages). So there will be 3 choices for the status field (OPEN, ARCHIVED, CLOSED). Open by default will keep the item listed on the sales rep's page, and on the master page. If the choose archived or closed, it will remove the item from the master and sales rep and move it to the archived or closed page. If we change the status in the archived or closed page to open, it would put the item back into the sales rep and master page. Each sales rep page should only show what items they have based on their sales rep initials, and sheet name (their initials) See excel file attached for details and the sheets represent the different pages. Each page should look the same and have logo, and look good. Doesnt have to be exactly like the excel. '