Populate summary page in Excel

[Carissa_aggie]

I am creating a contact list with a summary tab, then a separate tab for each contact. How do I get the information from each tab to pull to the summary tab without having to link every cell individually?  Each contact tab is identical with information pulling into 5 separate rows on the summary tab with multiple columns in each row.

Example of Summary Tab:

Example of Contact tab:

[#2]

Hi @Carissa_aggie 

I think you should do it other way, create a master list, give each row a record number (unique no/serial no) then you can use XLOOKUP or VLOOKUP taking that record number to pull the information from the mastersheet to contact tab as per your need just by changing the record number. Once you have master list you can play with data as you like it.

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert | www.ExcelExciting.com