Howdy. This seems like it should be simple, but I am an absolute idiot
when it comes to macros and/or code.

Here is what I have:
Use a template for quotes, Dropdown in B12 lets me pick out a product
group, in C12, another gets the size, D12 displays the product code,
various lookups in Col E,F,G,H give breakdown for parts list, which in
turn are priced in Col. I from another lookup list.
All well and good, but I include a small thumbnail in Column A, that
prints out with the quote.
Currently I copy and paste from a list of products that are on a
sheet named "Products".
Obviously, this becomes very tedious.

Is there any way to automate this, so that after I finish entering the
code, a macro would lookup the Product Code, then copy the appropriate
cell from the "Products" sheet and paste it into the appropriate cell
on my quote sheet?

Have tried recording a macro, but it only does:
Sheets("Products").Select
Selection.Copy
Sheets("Qoute").Select
ActiveSheet.Paste

Any help would be appreciated muchly!!