Excel formula on iPad

Witsend_Solutions To achieve that you can use INDIRECT and named formulae. 

On the Formula ribbon, Define Name. Where it says "Enter name...." enter, for instance, "shBHP" (without the quotes). And where it says "Select range......" enter the formula (below) and press OK.

=INDIRECT("BHP!C2")

Then, on your Summary sheet, where you want to display cell C2 from BHP, enter

=shBHP

Now, no matter what you do in sheet BHP, the summary page will always display what it finds in C2 of that sheet, provided that the sheet exists, of course.

EDIT: Wondering if you can actually do this on Excel for iPad (don't use it myself). Couldn't find how to enter named ranges/formulae on Excel for iPhone. It's just too small and inconvenient, I think. But a sheet made in regular Excel with the above method will work as intended when you open it in Excel for iPhone. So I expect it to work as well on the iPad.

If you must create the solution on the iPad, you can enter the text BHP!C2 anywhere (e.g. in A1) on your Summary schedule and enter =INDIRECT(A1) where you need the content of BHP!C2 to show-up.