I need a formula to link data in a reference sheet, to data in the other
sheets in the workbook.

I have one worksheet that I am using as the reference sheet. The name of
the sheet is 'Byes'. In this sheet, I have data in column C that directly
corresponds to the data in column D. Specifically, column C has text typed
in it and column D will have a number value typed in it. I need this data in
columns C & D in this sheet, to match with corresponding Data in other
sheets. Also, if I change the data in column D in my reference sheet, the
data should change in the other sheets in the workbook. Here's an example.

In my reference sheet named 'Byes': C2 = 'Arizona' and D2 = '7'. In all of
the other sheets in the workbook, if the data in column C = 'Arizona', the
data in column D should = '7'. Also, in my reference sheet, the data in C3 =
'Denver' and D3 = '8'. In all of the other sheets, if the data in column C =
'Denver', the data in column D should = '8'. And so on and so forth.

Simply put, I have data in my reference sheet named 'Byes'. Data in column
C has a corresponding value in column D. In the other sheets in the
workbook, the data in column C should have the corresponding value in column
D according to my reference sheet.

Hopefully I didn't confuse anyone too much. Thank you in advance for your
help.