Create Huge Editable Database in User Friendly Way

Hi everyone,

I have been away from Excel for a bit so I'm trying to get my bearings again. I am taking a workbook from someone else and trying to update it. As it currently stands, I will receive an order from my boss and it contains information such as part numbers affected, dates, and various other things.





Is this layout manageable or should I rethink how I want to present this information?



I have a "Dashboard" which will show the orders and statuses such as completed, date, notes which I would like to pull from the database sheet.

I have an "Add" sheet where I can copy/paste the cells from my boss' order sheet. There is a macro button that will copy the data to the database, then clear the add sheet so I can start fresh when he sends me another order.

I have the database sheet which stores the info from the "Add" sheet. This will just keep building over time.

The main sheet I'm having issues with and confusing myself over an answer is the "Update" sheet. I would like to type in any order # that is in my database and have it populate all of the part #s and other info, but ALSO edit information there? I am making machining programs and I'd like to type in the order number, see all part#s affected, and set in a drop down box that I have completed, not completed, each program. Is there a way to lookup multiple rows/columns at once AND edit this info? Or should I restructure?


Hopefully this made any kind of sense. Thank you for reading.

*PS*
I am just posting for the first time and it is telling me when I upload my workbook to upload and scroll down to "Go Advanced" but I'm seeing nothing of the sort. If I didn't upload this properly, let me know.