Pop-Up Window to Pull Info to Another Sheet.

Hey everyone.

Take a look at my sample to understand what I'm asking.

Currently on my full project I have it so that if an X is in the box on the master sheet it pulls that line to the corresponding sheet and makes a list out of it in the "requirements" column. I did this just with an =If function. After this I have to type in the stuff in the "code" and "comments" sections.

I would like it to work so that when that X is initially typed in the box it opens a pop-up window that lets you type a comment right there from the master sheet that gets pulled to the reference sheet as well. And I would like there to be a drop down in that pop up that lets you choose which code it gets. My goal is to not have to go to the other sheets whatsoever except for printing.

ex. For AAA, I know that a requirement of "4 inch brick wrap" is needed. I click on that box "B12" and I want a window to open that says has a comment box and a drop down that lets you pick whether its a DR, DM, G, CCR etc...(those codes are explained on sheet AAA if you got confused). Then I would like all of this information to be pulled to Sheet AAA so that it is listed in column a: "4 inch brick wrap", column b: code, and column c: comment.

My large project has over 200 lines of various requirements and more get added and taken away every day so it also has to be relatively simple to add new lines of requirements and remove old ones as well as adding new columns(FFF, GGG, HHH etc.) to the master sheet and new sheets to the overall document without screwing up the macro or document altogether.

Not all at once. If you're going to look at it at least leave something saying it's possible or not possible so I know to head down a different direction with it.