Creating a summary sheet

[Tazzbjs]

Ok, need to create a summary sheet. Now, I need to pull the total in cells I20 & I52 on each sheet to the summary page along with the employee name from B2. Is there an easy way to do this quickly?

 

[Jeffrey Mahoney]

IF Cell B2: Acosta, Wally 2315

Cell I20: =INDIRECT("'"&B2&"'!I20")

Or you could put a name in Cell B2 and use another cell to give you the sheet name for hat person. Then you use that cell with the sheet name in I20