I have a workbook with 200 sheets. I have a summary page with a list (in column B) of unique values that correspond with cell A4 on my other sheets. I would like column C of my summary page to find the sheet that has the same value as column B in cell A4 of a sheet and then return the value of A16 from that sheet.

Example: Sheet "Summary" B2 = "1343345". Sheet "Client5" A4 also = "1343345" so it returns Client5 A16 (which is $57,467.13) to C2 on Summary Sheet.

Thanks is advance!