v like lookup, gather info across sheets

[LegoMason]

Hello,
I need to make a summary sheet which pulls based on the row heading (which is the sheet name) and the column heading (which is the identifier of the data in the sheets) I don't need to add the numbers together I just need a quick way of populating the information. I attached an sample data file which is like 1% of all my data (hence the need to automate this task).

Thank you!

 

[bosco_yip]

Try,

In "Summary" sheet C2, enter formula copied across and down :

=IFERROR(VLOOKUP(C$1,INDIRECT("'"&$A2&"'!$A$1:$C$50"),3,0),"")

Regards
Bosco

 

[LegoMason]

Thanks for the assist but that formula isn't returning any data, see attached.

Any other thoughts?

 

[GraH - Guido]

Your formula is
=IFERROR(VLOOKUP(C$1,INDIRECT(""&$A2&"'!$A$1:$c$50"),3,0),"")
Bosco's was:
=IFERROR(VLOOKUP(C$1,INDIRECT("'"&$A2&"'!$A$1:$C$50"),3,0),"")

 

[bosco_yip]

Or, highlight/enlarge the difference as in :

Your formula is :
=IFERROR(VLOOKUP(C$1,INDIRECT(""&$A2&"'!$A$1:$c$50"),3,0),"")

My (Bosco's) was:
=IFERROR(VLOOKUP(C$1,INDIRECT("'"&$A2&"'!$A$1:$C$50"),3,0),"")

Regards