Merging Multiple tabs into 1 sheet

[Aevans0001]

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

(

Please Login or Register  to view this content.

I also toyed with the extra space between families as in this

Please Login or Register  to view this content.

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

[FDibbins]

Hi, welcome to the forum

I suggest that you upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

[Aevans0001]

Here is a sample workbook, thanks for all the suggestions.

[sandy666]

I'm not sure I understand it well but maybe PivotTable: