Removing a value from one sheet and replacing it onto another.

[Adam,P.]

Hello everyone I need a little help developing a macro to help me with an inventory database. Basically i need to have sheet one as my main inventory then sheets 2 - around 17 as receiving (or sign-out) sheets for specific people
. So basically i would have a large inventory section i would enter in manually on sheet one then when i scan that piece of equipment out to a person's corresponding sheet it would find it on sheet one and move it to that person's sheet. So this value would no longer be in sheet one but in, lets say sheet 5. Also there is an time where i would put that item back into inventory so when it is in sheet 5 and i scan the physical item back into sheet one it would again move it. Is this possible? and can anyone help me with this code? thank you.