Hyperlink or fomula to add result in comments of a cell

HI Team,

Good evening. Need a help with Excel summary.

I have few sheets like active employees, New Hire, Attrition and few more sheets. for all the sheets I have prepared a summary by updating the numbers using countif of new hire and separation as per the department. Currently What I am doing is if i enter the new hire number as 5, i search for the 5 employee id and put it in the comments of the cell so people who sees can see the comment who have joined.
Is there any way that the cell can automate the countif output and update the same in comments or any hyperlink types will help. I am not sure on w

Thanks in advance.
Naveen