Take full name from one worksheet, make appear as first name last initial in another

[CaptQuay]

I am trying to create a workbook, with multiple worksheets, on my daily report worksheet I need several things:
1st: Have first name and last initial (John S), but on the individual worksheets we have the full name displayed (John Smith) . I know when it is on the same sheet, I can use the =LEFT(AG2,FIND(" ",AG2)+1), but what is the formula to bring from another sheet. I used to use the ='sheet#'!$A$2 to bring the full name across.
2nd: Any of the other info I bring across, if no data I get a "0", how can I have a blank from one page to leave blank on another.

 

[awoohaw]

You only need the apostrophe if the sheet name has a space in it.

Try:

Book1
	AG	AH
1
2	John Smith	John S
3	John
Sheet4

Cell Formulas
Range	Formula
AH2:AH3	AH2	=IFERROR(LEFT(Sheet4!AG2,FIND(" ",Sheet4!AG2)+1),"")

For the 0 Values:

=IF(Formula= 0, "", Formula)

 

[CaptQuay]

Thank you

 

[awoohaw]

You're welcome,
Best Wishes.