Pull data from a single Cell in many diffrent sheets to the summary sheet

[iancghln]

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?

[simarui]

I had a similar need which i eventually wrote a macro for... however in searching for how to do so i stumbled upon another thread in which a link to an addin which does precisely that Pepe Le Mokko posted...

http://www.excelforum.com/excel-prog...lly-added.html