Vlookup, Iferror or alternatives

[custhasno]

So I have a sheet with a tab for each project (that is a check list) and a summary page. Not all project sheets are identical, so the data I want to display in summary can be on slightly different cells on different sheets. I want to summarise a few cells from each sheet and was thinking the only way to do so was to use vlookup chained with iferror to search each sheet for the project name to match my summary table and then display the data from that projects corresponding cell. The problem is I have 45+ projects so the chain of the formula will be too large to handle easily.

Is there a handy way to display a specific cell from the sheet depending on the name of the sheet

 

[Joe4]

There really isn't enough detail to give you a good solid answer (don't really know what it is you are trying to return from each sheet).

However, what you are describing sounds like a Relational Database. While you can "brute force" Excel to act like one, this is NOT what is was designed for, and hence tends to get slow and clunky, especially as your data grows. It would be far more efficient in Relational Database program, like Microsoft Access or SQL, as this is precisely what these programs were designed for.

If you are stuck using Excel, you may want to look into using Power Query in Excel, which allows you to do database-type operations from within Excel.
We have a forum for all the Power products here, named Power Tools.