Questions, drop down, store answers

[JoeK210185]

Hello all.

I hope I can explain it properly what I'm trying to achieve.

I basically have 10 or so advisors who will all have their own spreadsheet, all with the same questions on each one.

What I need to know is, how do I have a master copy in the background that will capture every set of answers the advisor puts in.

For example Advisor 1 pick the answers...

Q1 Q2 Q3
orange large carton sumbit


Now when the advisor puts the answers in an presses 'submit' I want the answer to go to a 'master' sheet with all the other entries?

Is it possible as I'm not sure. Thanks.

 

[JoeK210185]

That code will keep Row1 data

I've got heading in A1-H1 and the actual information in row 2, but I only want to keep the information in A2 and B2.

Sorry I'm a bit of a div when it comes to this stuff.