Combine dropbox selections into new columns?

[oceanorigami]

I'm just going to present a picture to you of what I'd like then maybe you can tell me if it can be done.

FFLX9g.jpg

What I'm after is an easier way to get data combined without having to type it all out. If you look above I would like to have A-C actually as dropbox's or listbox's, something I can click, then drop down to the proper name and select it. Then on E I'd like a timestamp for when this action was done with the date and time as shown along with the reason. Then in F I'd like the Name fields combined so I just need to right-click on F and copy/paste into the other program I use.

Can this be done in Excel though? If not can MS Access do it? Anyways let me know what you think. Thanks

Maybe one column can just be the names of everyone with a selection box and I click this stuff then when I am done it resets?

[Kenneth Hobson]

If you have all the names, put them in a named range and use the List option in Data Validation for the "drop boxes". The timestamp would be an IF() based on the value of cell not being "" and use =Now() to insert the current date/time. The F cell is another IF() and would just use concatenation operator "&".