1) I am suppose to create data entry using vbaexcel to be able to generate a worksheet(in excel) that is able to show the data from the entry.
2) The information should at the same time be captured in a database(which is dunno which one is better) for retrieval in the future....this is only a small part of it (the data) and it will eventually link to other database tables.....

Matt see if you help to suggest the process flow ie..should i create a excel database to link to Acsess.or straight from excel/vba userforms to Access....
?thanks!!