How to cause a selection in one cell to change options in another cell using a Listbox

Hi,
I'm pretty new to VBA as well as involved formulas in Excel. I currently use Excel 2010.

Here is my problem:

I have a workbook with two sheets on it. One is for users to enter data ("Data"). The other is the tables by which I want the user to choose from using Comboboxes and Listboxes ("Tables").

In "Data" there are two Columns with the headers: Color (ColA) and Inventory (ColB).

In "Tables" there are different ranges in different columns. Range1=Color (ColA) Range2=Inventory1 (ColB) Range3=Inventory2 (ColC).

What I can't figure out how to do and need to happen is that when a user clicks on a cell in the Color column on ws "Data", a Combobox should come up with all of the items listed under the Range Color from ws "Tables". The user selects one and it puts that choice in the cell that has been clicked upon.

The user would then go to the next column in ws "Data" and a listbox should appear. The items in the multi/multi select listbox that would appear would depend upon what the user selected in the previous column, Color. If it was "Red" then the listbox would choose an input range from Inventory 1 in ColB. If it was "Green" then the listbox would choose items from Inventory2 in Column C to display.

The user would then be able to select multiple items in the listbox and the items selected would appear in the one cell that was selected, not separated by anything.

I've got the combobox part figured out. Getting the listbox to work and to change its display depending on what was selected in the combobox is right now beyond me.

Maybe I shouldn't be using Listboxes? Maybe I should be using a Userform? Maybe I should be using VBA Code? Maybe I should use nested IF statements? I'm totally LOST

I've attached a sample worksheet that displays what is described above. If anyone can please point me in the right directions, I would appreciate it.

I can't use DATA VALIDATION, because the fontsize is too small, and I need to select multiple items in the second column.

Please help!

Mark