Pulling data from another worksheet

[Susan]

Ok, here is my question. is there a way to put in cell A1 of one worksheet
the name of the other worksheet, example "ORANGE" and pull in data from the
workbook orange cell G10

is there some type of formula i can put in cell A2 like =
sheet"ORANGE",cellG10

my problem is i need to pull in over 100 worksheets and we are constanly
adding new ones everyday and the people entering the information do not know
excel so i need to write a formula that pulls in the info automatically into
cell A2 when in cell A1 they type in the worksheet name.

Hope this is not confusing.

Thank you!

 

[Jim Thomlinson]

I think you want indirect...

In Cell A1 type in Orange
In cell A2
=indirect("'" & A1 & "'!B2")

Which will grab Cell B2 for the worksheet called Orange.

What indirect does is it allows you to retreive infromation from a cell
address taht you have created as a text string. make sure that you have the
single quotes around the sheet name...

 

[Susan]

Thank you worked perfectly!!!!

I think you want indirect...

In Cell A1 type in Orange
In cell A2
=indirect("'" & A1 & "'!B2")

Which will grab Cell B2 for the worksheet called Orange.

What indirect does is it allows you to retreive infromation from a cell
address taht you have created as a text string. make sure that you have the
single quotes around the sheet name...