Automate Excel worksheet to apply information in specific row to another worksheet

I have 2 worksheets setup in excel. Worksheet 1 is dynamic information that I edit weekly. Worksheet 2 is static and will not change. One column in worksheet 1 numbers that are associated with a particular row in worksheet 2. For example, if worksheet 1 column C has a 4 in it, I'd like to apply what is in row 4 in worksheet 2, to replace that number with text.

Does that make sense?