Can this be done?

[IluvPivots]

Ok...I have been tasked with creating a rather dynamic workbook.
I have very limited VBA knowledge, but I'm pretty sure this can be done. Hoping someone can help.

Problem: User filling out form/spreadsheet needs to be able to make a selection of more than one "item" from a list for one particular category. The "items" need to then automaticlly be populated into an excel sheet so that reports can be generated based on the selections.

I had originally just used columns with headers, but the list is long and it would be too many columns. (Since there are many other columns besides this one) My vision is that a "form" pop up and the "items" could be selected there, saved and excel then generates the selection to the sheet in seperate columns.

So, if the person clicks in cell A, a form pops up with selection, user selects "Item 1", "Item 2", "Item 3" in the form, closes form, and the items would then be populated in Col A, Col B, Col C etc.

Any suggestions?????? I know you people are awsome at this stuff!!!!!!!!!!!!!!!!!!!!!