Need to create spreadsheet for asset management

I need help creating a spreadsheet for tracking our laptops and projectors to our traveling users. I'd like the first sheet to be where I can search (dropdown box?) for the user, then for the hardware, and be able to log the hardware in/out to that user. I'm guessing the subsequent sheets will be where the data is? I'd like to be able to add or remove hardware and users as needed, and have a running log of who has had what equipment and when.

I have the drop down boxes set up. What I need help with most (I think) is setting up the log.

Here is what I have so far - the names have been changed to protect the somewhat innocent...

You've only filled in sample information in one tab. If we could see the others with sample data, including your log tab, it shouldn't be that difficult to help you get your log working.

Sorry, on that sheet the first page or tab is where the info will be entered per occurrence - B1-B3 are drop down boxes that pull data from the Hardware, Users, and In-Out tabs. I don't know how to create a drop-down box for the date so I figured I'd just enter that manually. Then when all 4 of those fields have been entered I'd like them to post on the Log tab, giving me a running list. This is where my problem lies.

Don't worry about drop-downs at this point. But if you can't show us how the data will look, it's hard to help you devise a solution. Just fill in a few lines on each tab showing how you envision it might look (with no formulas, just hard entries).

Okay, here is a sample of what I'm looking for on the log tab.Mobile Inventory with sample log.xlsx