Survey Results

First I would like to say hello because this is my first post. I have been to this site before and was able to find help, so Thank you! Now I have joined and want to give back.

I have a slightly complicated problem so I am hoping that someone here can help me out. My company started handing out guest survey cards at over 50 venues. Now the cards are coming back to us and we need to enter the data then analyze it. I have created a sheet to do everything there is just one macro that I am having a hard time with and I don't know what steps to take next.

The first sheet is the "Data Entry" sheet. Column A is a vlookup for the venue name, Column B is the Venue code(this then fills column a), Columns C-D are the questions on the survey. The questions can only be answered 1-4 and the cards are not in any order when they are entered in.

After the data entry person has entered all of the cards I would like them to be able to hit a "Move Data" button. This is where I need the help. The data at that point will then be moved to the "Data Sheet"

Then data sheet is laid out like this:

Row 1 is a list of all of the venues, Rows 2-8 are data that is pulled from the card entries in rows 9 - 5000

So what I need is the "Move Data" button to do is:
Look at Column A in "Data Entry" and match that venue with the venue name in Row 1 of "Data Sheet" then copy the answers in Column C - G to the bottom of the list on the "Data Sheet"

I have attached a version of the sheet with all the venue names blocked out so you can get an idea of what I'm trying to accomplish.

Any help in this would great and please let me know if I was not clear enough or if you need more information to help me.

Thank you!!!