Share data from multiple worksheet tabs to a master tab

Hi have (in one Excel file) multiple tabs: MASTER, ABC, DEF, GHI, etc. Need help doing the following:

I want value that is calculated in cell I2 of ABC to flow automatically to cell C2 in MASTER tab, cell I2 of DEF to flow automatically to cell C3 in MASTER; cell I2 in GHI to flow to C4 in MASTER, etc. Using Excel 2010

You could put this formula in C2 of MASTER sheet:

='ABC'!$I$2

and then copy this down and edit it in successive cells so that ABC is changed to DEF in C3, and to GHI in C4, and so on.

Alternatively, if you have a list of all the sheets (eg in column B), then you could put this formula in C2:

=INDIRECT("'"&B2&"'!I2")

and then just copy this formula down.

Hope this helps.

Pete