Microsoft Excel function formula

Setup Excel function to reference a value on another sheet by using an existing column value. It would take that refrenced value and post beside it in next column. Example You have following values on multiple sheets: Sheet one Col C Col D ARZ blank TB blank ATL blank Function would recognize all ARZ, TB, etc. on all sheets – then, to the column just to the right, reference a single sheet that holds a value as such: Sheet 14 Col A Col B ARZ 3 TB 17 ATL 6 End result: I can enter values (a single or 2 digit number) to sheet 14, column B. It would relate directly to column A. Then, every Col C on every other sheet would post Col B value (from sheet 14) to the column to the right of it on its respective sheet. Sheet one Col C Col D ARZ 3 TB 17 ATL 6 I would send you Excel file, you would program this function then send it back to me. File is attached. Use PMB for comments or questions. I need this the quicker the better.