programmatic vlookup on "summary" sheet on save

Taking this project a step further, I quickly ran into another small problem. I can fix it with a macro but I dont like the slowness of it and would like to do this programmatically.

so i have attached the file that Tiger helped me with earlier. Here is what I am looking to do.

sheet 1 is the entry sheet.
sheet 2 is the lookup sheet.
sheet 3 is the datatbl sheet.

On sheet 1 you enter your data, after completing a row of data I want it to programmatically (maybe on save?? maybe on close?? I could even tie it to a button click event if it takes a long time) count the total number of rows on sheet 1 and do VLOOKUP's and references (one per row) on the datatbl sheet. This data will be copied and pasted special (values only) over the top of itself (ugly maybe ... but I dont know a better way and i have the code for it). I could hard code these on the datatbl and assume like 10000 rows, but then every save when it refreshes it would take forever. Because the ability at anytime to INSERT a new row at any point on the entry sheet is possible, the vlookup would have to do a refresh to make sure no rows got missed.

Am I making this harder than needs be I just want it to (on some event) count the rows on entry sheet and put the corresponding data into the datatbl using the vlookups and references as shown.

Please see the datatbl sheet to see what I need for each row programmatically.

-EDIT: The reason for all of this is because I want to be able to IMPORT the lookup values of the text (ex/ 3001 instead of the word CARROT), because this is being imported into an Access Database that uses these IDENTIFIERS instead of the words. So I need the entry sheet to be user friendly where they can select the text and then have a hidden sheet (lookup tbl) that contains the ID's of these values and on some event have all the rows from the entry sheet get "changed" into their ID numbers and loaded onto the datatbl. One per row. Easy right??? :-)