Hi,

Am Mon, 22 Jul 2013 04:04:33 +0100 schrieb PamaLove8628:

I am working on a document I need help indexing. I have 44 worksheets
in the same document with detailed information pertaining to each
individual case. I want certain bits of these details readily available
in one worksheet, like an index or a summary.
+-------------------------------------------------------------------+
|Filename: Sample.zip |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=892|
+-------------------------------------------------------------------+

if you could change your sheet names to "Patient 1", "Patient 2" you
could use in sheet Index A2:
=IFERROR(VLOOKUP(A$1,INDIRECT("'Patient "&ROW(A1)&"'!A1:B1000"),2,0),"")
and copy to the right and down.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2