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!