Store and Retrieve User Inputs from Data Form

Hi All,

I have an Excel file created by a previous employee and it appears they didn't have a chance to finish the file. I may not be able to post a sample of the file as it contains confidential information but I will try to explain the situation to the best of my abilities.

Currently, on opening the file the user is prompted to fill a user form for a list of items and the year they choose to fill out. The user form contains a drop down list to select the year and text boxes for the user to input data in. Upon completing the list, I would like the data to be stored in a specific spreadsheet dependent on the Year selected. Therefore, the user can input data for multiple years and have a graph to create a YoY comparison. Also, if the user chooses to change data in a previous year they do not have to refill the entire list out.

To give you an example: User selects 2010 and fills out 10 apples and 5 oranges. Then selects 2009, 6 apples and 2 oranges. Now if the user goes back to 2010 it should auto populate the 10 apples and 5 oranges and allow the user to overwrite if necessary.

Thanks in advance for your help.