So I am trying to create a page with everyones name on it, from about 10 different tabs for our family reunion. So in other words I want info from tab "Alfred Post" to report to tab "Mail Merge" First Name, Last Name, And Family. Then I also want the same info from the tab George Post to the mail merge tab.

Here is how I am currently doing it, lol

( 
=IF('Alfred Post'!$N2="(Alfred)",'Alfred Post'!A2,IF('Bertha Myers'!$N2="(Bertha)",'Bertha Myers'!A2,IF('Fronie Evans'!$N2="(Fronie)",'Fronie Evans'!A2,IF('George Post'!$N2="(George)",'George Post'!A2,IF('Gertrude Vaught'!$N2="(Gertrude)",'Gertrude Vaught'!A2,IF('Hermina Falck'!$N2="(Hermina)",'Hermina Falck'!A2,IF('Louis Post'!$N2="(Louis)",'Louis Post'!A2,IF('Lucille Johnson'!$N2="(Lucille)",'Lucille Johnson'!A2,IF('Martha Hoyle'!$N2="(Martha)",'Martha Hoyle'!A2,IF('Norbert Post'!$N2="(Norbert)",'Norbert Post'!A2,IF('Rita Evans'!$N2="(Rita)",'Rita Evans'!A2,IF('Trenna Kremers'!$N2="(Trenna)",'Trenna Kremers'!A2))))))))))))))

I also toyed with the extra space between families as in this
=IF('Alfred Post'!$N2="(Alfred)",'Alfred Post'!A2,IF('Alfred Post'!$N2="",IF(H1=" ",IF('Bertha Myers'!$N2="(Bertha)",'Bertha Myers'!A2,
All these formulas work, except the fact as I copy them the values change from N2 and A2 for the other sheets. So if I could keep Bertha Myers at N2 and A2 until Alfred Post N17 was blank and then following lines would use Bertha Myers N3 and A3 then these formulas would work for me.


Thanks Adam

Using Office 2013