Click, search(?) and copy/paste in same sheet

[PHxLantern]

I have a question about a possible VBA code that I am not sure if it is possible. I'm learning some code but a lot it is still over my head.
I have 3 separate small warehouses with 2 of them needing materials for me to order for them.
I have a sheet with some items and serial numbers associated with those items. It's basically a list of possible items for them to request. A little over 400 items, give or take.
What I am thinking about is having Items in column A with the serial or product numbers in column B.
The reason for the separation is sometimes the serial number will change but not the product name and vice versa.
I would then like to combine the 2 in to a hidden column. I think I can do that with a formula easily.
The reason for the column to be hidden is just to keep things looking simple for others who are looking at this sheet.
Here's where I am probably overthinking this.
I want the others to be able to click on either item or serial number, have the corresponding info from column F put in C and input box pulled up so they can put in a quantity request and have that go in to Column E. I kind of fooled around with message box inputs and I somewhat understand how that works.
I already have a submit button figured out to email me the filled out columns. And the reason for the empty column is so it's not all mushed up when they email it.
Is this even possible or am I a bit crazy?

ColumnA	ColumnB	ColumnC	ColumnD	ColumnE	ColumnF (Hidden)
Item A	Serial A				Item A+Serial A
Item B	Serial B				Item B+Serial B
Item C	Serial C				Item C+Serial C
Item D	Serial D				Item D+Serial D

 

[PHxLantern]

Bump.
Here is hoping someone can help with an answer