Help creating interactive userform.

I have a spreadsheet that I manage that I am looking to simplify and don’t know if it is possible.

Currently the data is kept across three spreadsheets; current items, removed items, added items. As items are removed I cut them from the current items page and paste to the removed page and as items are added I type them into the added items page and then copy/paste to the current items page. The current items page is then sorted by column A then column E.

What I am trying to accomplish is to create a user form that will have a search field and listing box to allow lookup of current items. A second tab for removing items and a third tab for adding items. I need to keep a history of what items were removed and added and when. I am also trying to keep the user interface simple.

If this is even possible I would be grateful for even a point in the right direction.

I have attached a workbook with data already included and a crude representation of the user form I am looking for.


Test Copy Upper Warehouse Product List.xlsm

I have split the data as I have to print the current inventory sheet daily and found it easier to manage by removing and adding items to that sheet and keeping history of items on the seperate sheets. Using only a status column had the single sheet growing to large to fast and made it harder to read as to when the item was added or removed.