sorta like consolidate I guess

I have about 50 sheets in a single file. Each sheet is identical in terms of which cell the sheet title is located in.

I would like to have a summary sheet that contains a list consisting of the A2 cell data from each sheet, which is the title cell for each sheet.

Of course, it would be great if I could do this without linking up each cell to the summary sheet one by one.

Also, if possible, I would like to bring over certain detail data from each sheet into the summary sheet and have it correspond to their appropriate title cell.

For example, each sheet has net income located in column C, but on different rows for each sheet. Is there a way for excel to just go find the net income for a corresponding title cell and put it in the appropriate row in the summary sheet?

Thanks for looking.

That wasn't exactly what I was looking for, but that was a learning experience. I didn't realize I could use whole columns as look up values and table arrays. very interesting. but, yeah, I didn't want to individually link them up one by one because there are literally like 60 tabs. still, your example is much appreciated. I will keep that method in mind in the future.