I need help with VBA excel

Hi,

I am very new to VBA, but i believe that vba will help me in to keep track of my items. However i met up with some problems. Thus i hope you are able to help me out.

Problems that i face:

1.The cargo Box can only store 30 items whereas the refrigerator can store up to 50 items.
2. Items that come in are very random and can have up to 30 items each day.
3. Special items need to store at special location.
4. This list is shared between friends thus can be be very difficult to maintain the same quality of work. thus is there any method to ask the personnel to log in this file via username or pw?
5 i also need to keep track of how many same product came in from the same supplier.

I manage to solve the storage location by using countif function and a if function, like if the items in cargo box is item 61, it will be at cargo box 3.

i believe that VBA in excel should be able to help me, but i really got not enough time to explore.I need a good way or any method to solve all my problems above. I also know that i am kind of asking for too much, but i am sort of desperate already as my items keep piling up and is super messy. Urgent help is really needed. thus i really appreciate your response so much.

Thanks and Regards