If I have sheet ABB, ALL, BAR, and I want to return the values from C2 on
each sheet, how can I do this automatically?

List the sheetnames in say, A2 down
Then you could use this in B2:
=INDIRECT("'"&A2&"'!C2")
Copy B2 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---