Hello all, first day here and I am looking for advice how on how to setup a quite complex function.

Ok so I have an inventory sheet and I am having issues with manual entry (incorrect part numbers and or quantities) so I would like to setup an automatic entry button essentially. I would like a button that when clicked will being up a search where you can put in a part number and it will search the current page for that part number, it would then ask for a quantity and then update the current cell total (IE, if the current quantity of part a was 500 and 1000 came in it would total up the cell to the 1500) once the cell updates it would also change a date inventoried cell to the current time and date, and also change a drop down menu from ordered to inventoried. I hope that even half of what I said makes sense and I really hope this function is possible.

Thanks in advance.