Cell formula to record many values and date entered

Hey, I'm trying to make an excel spreadsheet for a university course, but I don't have much knowledge of excel, however I am quite computer literate. I'm trying to make it so that a student can input a value (eg 5) into a cell, and then have excel record that value along with the date the value was inputted on. But then it must work so that either the value is recorded in a drop down list, or on another spreadsheet, so that another student can come along on another day and input a new value and so on (I'm assuming macros can be used in excel, and could be used somehow to move the data to another spreadsheet). Also so that the other students can look at the values recorded over a certain length of time. Can anybody help me out with this? Please!