How to collate all results thru formula.

Hi Best Minds Team,

Good Day. It has been a while. I hope everyone is doing great today.

I need help.

Our company had recently sent an Excel Appraisal form to its employees. All staff have to appraise themselves, Directors have to appraise the staff.



Performance Appraisal Form for Self-Appraisal - Formula.xls is like my masterfile wherein I had created an individual worksheets for all the employees which contains their self appraisal. So their scores, I need to key in in the masterfile worksheets. It was a bit easy for me. My goal now is to show also the scores from the directors on how they rate us, the staffs. Performance Appraisal ross.xls, Copy of 2 PA for Management Non-Executives -Dr.Kuncha Update.xls & Latest Kenneth Non-Executives 16022013 (Abhi update 060213).xls are the directors appraisals, you would see that these files also have different worksheets for the staff. I need help in making it faster in copying their scores to the masterfile. Right now, I am manually copying the directors' scores in my masterfile. I thought, why not consult the masters of excel.

Please help. Desperate

Thanks.