Building shopping cart by selecting items from inventory

I would like to create a spreadsheet that does the following:

One tab contains a list of items that are available (an inventory), with each item having values associated with it. There is an option (pull-down) to select x amount of each item to be added to the current list of selected items. I guess this is analogous to shopping online...adding each item to your basket/cart.

On another tab (e.g. your shopping cart), each selected item and the quantity shows up, as well as the stats associated with that item.

I'm sure this is possible to do, but I'm not sure where to start. Any pointers to get me going would be great! I can think of other (less automated) ways to do this, but thought it would be fun to try this.

-----
This is what I plan on doing with this spreadsheet: My inventory will be my hiking/climbing/mountaineering gear. Each item will have other values associated with it (such as weight). For a particular trip, I would want to build essentially a checklist by selecting all the items I want bring on the trip. Other things can be calculated from the selected items such as total weight.

Originally Posted by dilipandey

Would it be possible to share the workbook? Thanks.

I haven't made anything, yet. I was mainly just looking to create a test workbook where I can explore the programming that would accomplish this. I have used Excel quite a bit, not nothing this program intensive.

Originally Posted by royUK

I would imagine that VLOOKUP might work

Thanks! I will take a look.

Attached is a workbook I made up that shows kind of what I am looking for. If someone could take a look and give some feedback, that would be great!