Can I pull data into a single column from multiple sheets using Index / Match?

[crossmark]

I have contact information from various sources listed in the same Excel workbook, but on different sheets.

I want to create a summary sheet that combines certain common fields from all of the various sheets.

For instance, on the sheet titled "Combined", I have a column named "Salutation".

I want to pull the "Salutation" data from "Sheet 1", "Sheet 2", "Sheet 3" and "Sheet 4" into the Salutation column on the "Combined" sheet.

In the various other columns on the "Combined" sheet, I'll want to do similar with fields like "Addressee", "City", "State", "ZIP".

I have successfully used INDEX / MATCH to pull data from "Sheet 1" like this:

=INDEX('Sheet 1'!A2:ZZ20,0,MATCH("Salutation",'Sheet 1'!A1:ZZ1,0))

But... that pulls only from "Sheet 1".

How can I pull also from "Sheet 2", "Sheet 3", and "Sheet 4" into that same column?

 

[SanjayGMusafir]

I have contact information from various sources listed in the same Excel workbook, but on different sheets.

I want to create a summary sheet that combines certain common fields from all of the various sheets.

For instance, on the sheet titled "Combined", I have a column named "Salutation".

I want to pull the "Salutation" data from "Sheet 1", "Sheet 2", "Sheet 3" and "Sheet 4" into the Salutation column on the "Combined" sheet.

In the various other columns on the "Combined" sheet, I'll want to do similar with fields like "Addressee", "City", "State", "ZIP".

I have successfully used INDEX / MATCH to pull data from "Sheet 1" like this:

=INDEX('Sheet 1'!A2:ZZ20,0,MATCH("Salutation",'Sheet 1'!A1:ZZ1,0))

But... that pulls only from "Sheet 1".

How can I pull also from "Sheet 2", "Sheet 3", and "Sheet 4" into that same column?

With Excel 365 in your hand you have a lot of options to work with.
What I haven't understood is or have partially gained is what data is on various sheet and whether you want to merge all that in one cell for one person?

Can you post some data sample that will make it much easy to understand.