Need to create spreadsheet for asset management

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