yogi_Pull Stats Based on Data From Latest Date In Teacher!A:A

Google Spreadsheet   Post  #2504

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-02-2018

question by: TSHIRES
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/LW6IGJSwRa4;context-place=mydiscussions
Nesting Formulas

I'm really new to this but I have been using =INDEX(A:A,COUNTA(A:A),1) to get the last value in a column and =Sheet1!A1 to get data from another sheet. Now I want to combine them.  I need to get the last value on the previous sheet and place it in my cell. I tried nesting them like this:

=Sheet1!A1(INDEX(A:A,COUNTA(A:A),1) ) 

and like this 

=INDEX(Teacher!BH:Teacher!BH,COUNTA(Teacher!BH:Teacher!BH),1))

and

=INDEX('Teacher!BH':'Teacher!BH',COUNTA('Teacher!BH':'Teacher!BH'),1)

but none of them worked. 

Here is my project. The data on the first two pages is collected with a form and then the thrid page is a report template that I can print out for parents.