I am attempting to create a sheet that I can import into my database which requires very specific column headers and format in general. However it's not very user friendly to enter data into that format. So I have another sheet that looks more user friendly. I'm hoping to get the two sheets to talk to one another so that my users can use the userfriendly sheet, but then when I import, I don't have to do any 'massaging' to get it to work.

Essentially, we are trying to create an attendance sheet with hours that our participants attended and any comments we may have on that session. Something that looks like this:

ID First Name Last Name 8/11 Comments 8/12 Comments 8/13 Comments
12345 Rob Smith 2 Did Great 1 Not so good
54321 Bob Harrison 2 He showed up

So the user would fill in the above table with the hours that the person participated on the date that they participated, and add any comments for that date. If they have a new participant, they'd just add that participant on the next line down. Then on my other sheet, I want it to populate like this:

ID First name last name Date Hours comments
12345 Rob Smith 8/11 2 Did Great
12345 Rob Smith 8/13 1 Not so good
54321 Bob Harrison 8/12 2 He showed up

The crux I'm running into is if my user puts in a new date and comment, I need it to automatically add another line with all the info. I'm getting stuck there, and don't really know where to go from here. E.G. if they type a '4' under Bob Harrison's name on 8/13, I need a new line on the second sheet that reads 54321, bob, harrison, 8/13, 4, and whatever comment they type.

Hopefully this makes sense, and if not, I'm happy to attempt to clarify in any way possible! Finally...order on the second sheet DOESN'T matter. So if it went Rob, Bob, Rob instead of Rob, Rob, Bob, that would be fine.

Any ideas out there on how I can make this happen?