Using cell as worksheet name to return data on that sheet

R

Rookie_User

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

T. Valko

Try this:

A1 = Sheet 2

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

That will return the value from Sheet 2 cell A1.

Biff
 
N

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?
 
R

Rookie_User

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

T. Valko

You're welcome. Thanks for the feedback!

Biff

Rookie_User said:
This worked perfect and saved me a ton of time, thank you so much for your
time and efforts, and your creativity.
Click to expand...
 
Top