Automatically update pop-up menus in spreadsheet cells

Hello.

I have a project-pricing spreadsheet for garden construction.

I use a reference table to update attributes of materials for example paving slabs, which includes things like supplier cost, unit size, jointing material etc.

I create a pop up menu using the reference table including all the types of paving listed, then copy that cell into the main pricing spreadsheet so I can easily select the paving type, which then references all the different attributes such as price, jointing material, unit sizes etc and updates the costs accordingly.

When a new material is specified I add it into the reference table, make a new pop up menu including the new material, then copy and paste into the main sheet

The issue is I'm costing large projects with many different areas per project, so when I add a new material I'm having to copy and paste into various project elements that may use the product, eg patio 1, patio 2 etc etc.

What I'd like to know, is it possible to have a cell reference another cell and be in the format of a drop down menu?

Basically so all applicable cells are automatically updated to the new pop up menu but then I'm still able to select an option from that menu?

TIA