Can you please explain VALUE($A$7) , this part of this formula. In particular meaning of $A$7 here


This part of the formula is simply anchored (locked) to cell A7. If you want to change when you copy the formula simply remove the dollar signs as appropriate.
Can you please give me the formula for Cell B9 data will copy from cell AE18 for this year


It will return a blank as we're not in 2017 for another 15 months but you could use this in cell B9:

=IF(VALUE(YEAR(NOW()))=VALUE($A$9),IF(AE99="","",AE99),"")

Robert