VBA to copy and paste data from drop down list to multiple ranges in different sheet(backup sheet) and replace existing value.

[Unsa25]

Hello to all the beautiful people in this forum.
I am stuck into a problem in which we have a drop down list in one sheet which takes values from another worksheet via vba as hardcoded values.
But i want if someone changes the value of particular list from drop down list that value to be replaced in the backup sheet and whenever a person click again on that data set from drop down it should show news values.

I have a list of total 150 values in drop down and each value is hardcoded into different sheet from where it takes value.

If someone can help and replace the values via vlookup or something else would be great.

Thanks in advance

 

[jkevz01]

upload your excel file here, maybe I can help you with