I have a workbook that contains 21 worksheets (tabs). The tabs are E1 - E20 and each one corresponds to an employee. The last tab is an employee key. The key contains a column with the employee name and then the worksheet number (E1, E2, whichever) that corresponds. I use the sort tool to put them all in alphabetical order and then I create a third column which is A1 - A20. I need a formula that I can place in the bottom right corner of each worksheet that will automatically place the corresponding A value (A1, A2, whichever) in that cell so that when I print out the workbook the A value is already there. It's basically like this:

Burton E3 A1
Dickerson E6 A2
Johnson E4 A3

So I need to place a formula on each worksheet that will automatically input the corresponding A value. I thought I could just use if and go down the line, if cell B2=E3, then the value should be whatever the adjacen cell is (in this case A1).

Does that make sense?