I have the answer. This seems to work for me.
=OFFSET('Defect Sheet'!E$8,0,ROW(E1)-1)

Thanks For your help.

--
Message posted via http://www.officekb.com