I'm working with Excel 97, but will be getting upgraded to the newest version
in a few days.

I would like to be able to create a two column list on one sheet - one
column has products and the other has prices. Then, on another sheet I would
like a user to be able to use a dropdown, or a form, to be able to select one
or more of these products (along with their adjoining price) to add to a new
sheet, or to remove as necessary.

I've seen something like this done before, but I'm not sure how to do it. I
can't use Access (which would be ideal) because no one else has it, and I
need multiple people to use this.

any help or suggestion are greatly appreciated!