Sheet Lookup Assistance.

And it seems like htere's something else I can't do. Blah.

I'm trying to create a sheet that takes cell entries from another sheet, and references data from sheets matching the names in the first column. To describe.

* There is a sheet, LIST, that contains names in Column A (ALEC, ADAM, WILLOW).
* Each of these names is it's own individual storage sheet for data on that person.
* On another sheet, I need to have a reference (I tried INDIRECT but it didn't work as well as I hoped) in a number of columns, to information in each named sheet. (IE: A1 is ADAM on LIST; on NEWSHEET, I need A1 to get a specific cell data from the reference in LIST's A1, the sheet named ADAM, and so on across the row for certain cells specified). Row B then gets data based on the name in B1 on LIST, and so on and so forth. The sheet would need to display all of this info at once, and automatically add in anything added to LIST.

Not sure if I'm explaining that right. Hopefully someone can help me, you guys have been very helpful so far.