How to: Return values from another sheet but vlaue not change with insert of row

I've attached a worksheet to help explain what I need. I've searched and found many answers from Offset, Index, Indirect. Neither work, at least with me, to return the results I need.

If you look on Sheet1 G2 - it's blank
Look on the sheet Test A3 - it has May 8 2012

I need Sheet1 G2 to always reference Test A3 even after I insert a row. So basically once I insert a row it should return a null value. What I will do then is enter data from the next day in Test A3 which will update in Sheet1 G2.

based on my spreadsheet you'll see that I need to do this for more cells but I think once I get the formula for one I can manipulate the remaining.

Any help would be greatly appreciated as I need this for our generator scheduling at work.

Hello

Try this, will return "" if A3 is blank

=IF(LEN(INDIRECT("Test!A3"))=0,"",INDIRECT("Test!A3"))

Thanks!!!!!!!!!!!!
Both worked. Only difference the indirect returns a value of jan-00 after I insert whereas the second suggestions leaves the field blank which is preferred. Thanks again

The alternative to INDIRECT() (which is volatile) would be INDEX() (not volatile):

=IF(INDEX(Test!A:A,3)="","",INDEX(Test!A:A,3))