Im currently using this on a sheet im working on how can i use this in another sheet with same info the name of sheet is "Employee info" and the employee names are in "A:A" and the dates are in column "F:F"

=IF(AND(MONTH(D2)=MONTH(NOW()),DAY(D2)=DAY(NOW())),A2&" ("&YEAR(NOW())-YEAR(D2)&")","")