How to update the data in the dependent list when changing the value of a dependent list cell?

Question

Macros

Good afternoon. Please help with solving the problem:
There is a table with three sheets:
1. Item_expenses
2. Definition
3. Initial data
In the sheet Initial data , data is entered by selecting values ​​from the lists on the sheets Item_expenses and Definition , but if the values ​​​​of these lists change on the original sheets, on sheet Initial data values ​​remain the same.
Challenge: When you change the value of a cell in the source list, you want the data to be automatically updated in the dependent list. For example, if you change the value Activ max in the Material
column on the sheet Item_expenditureto Activ min , on the Source data sheet in the Expense column , the value should automatically be updated to Activ min . If there are multiple duplicate values ​​in a column, they should all be updated.
File with examples: https://yadi.sk/d/70EfJj18wiA_jg

Answer 1

Well