I have a workbook with a ton of sheets in it and need to get stats off of it, so I created a summary sheet. In this summary sheet I need to create a chart with different columns that refer to biometric information. This info is different in each sheet, but is located in the same cells on each sheet. So, eye color is always in cell D60 and I want to create a list on the summary sheet so I can use a SUMIF formula to tally each one. Does anyone know of a way to do this without a macro?