Pulling data automatically from another worksheet

I developed a document with a pull down menu that uses VLOOKUP commands to pull values for certain metrics for about 7 departments at work. We need to write variance explanations against those metrics.

I am trying to have staff write the metrics on a separate worksheet so management can view all the data I have automated on top and have the variance explanations appear dynamically from the other worksheet.

Thanks for reading..