To be perfectly honest I doubt you can do this without VBA. You mention clicking a button but that of course implictly means invoking a VBA macro.

The data entry form is just not in the sort of layout that could be addressed easily by formulae on Sheet2. You would stand a better chance if the data entry form was arranged in a standardised table so that you could pick Item Numbers or Item descriptions from a data validation drop down box and use a VLookup to populate the description (or vice-versa) and then enter the Qty in column C. In fact why don't you just use drop downs to populate sheet 2 and avoid sheet1. NOt sure how you might handle the images or how vital they are.