Using cell as worksheet name to return data on that sheet

[Guest]

I have a column that contains the names of all the worksheets in the
workbook. I would like to fill the next column with values from each of
those worksheets. Is there a good way OR is there a way I can put a formula
in column B that uses column A as the worksheet name?

 

[T. Valko]

Try this:

A1 = Sheet 2

=INDIRECT("'"&A1&"'!A1")

That will return the value from Sheet 2 cell A1.

Biff

 

[Niek Otten]

Look in Help for the INDIRECT() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a column that contains the names of all the worksheets in the
| workbook. I would like to fill the next column with values from each of
| those worksheets. Is there a good way OR is there a way I can put a formula
| in column B that uses column A as the worksheet name?

 

[Guest]

This worked perfect and saved me a ton of time, thank you so much for your
time and efforts, and your creativity.

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

This worked perfect and saved me a ton of time, thank you so much for your
time and efforts, and your creativity.