Vlookup Using Cells with Worksheet Names

[helpexcel]

Hi,

I have a workbook where the column headings have the same name as a worksheet in the workbook. I want to compile the data from those sheets into one master sheet. Is there a way to use those headings as a reference for which worksheet to pull data from?

I would be using Column A as the lookup value. The data value would be in Columns A:X of the other worksheets. That would then be placed in Column Z:Last Column.

Thanks.