VLookups in Excel can help to change values in Excel tables based on a combo box value.
Question: Can I select a combo box value and have the data copied to a new table?
AFAIK the “new table” will need to contain formula that references the combo box, e.g. =vlookup(comboBox, Sheet1!Data, 3). If you want the new table to be empty and the contain pure values, it can only be achieved through macro programming using VBA.
Excel cells cannot be affected without a formula in it. It will stay an empty cell (without VBA).