Combining multiple lists into one !
 

I would greatly appreciate anybodies help with this:

I have 6 lists (defined as Nicki, Cathy, Dawn, Alison, PatJoy and
MikePauline). I downloaded an example from Contexture,

(http://www.contextures.com/excelfiles.html)

as to how to combine the lists, which I have attempted to do. However, I am
stuck as the example given only reflects how to do this for three lists. The
formula below megers data from 3 columns/lists to one:

=IF(ROW()COUNTA(Nicki)+COUNTA(Cathy),OFFSET(Dawn, ROW()-1-COUNTA(Nicki)-COUNTA(Cathy),0,1,1),IF(ROW()COUNTA(Nicki),OFFSET (Cathy,ROW()-1-COUNTA(Nicki),0,1,1),OFFSET(Nicki,ROW()-1,0,1,1)))

how do i incorparte the other 3 lists ?? Thanks in advance for any help !
Kind Regards
Adam194