Extracting Data from Various Excel File to Master Sheet

Hello,

I request you help on the spreadheets. I have filled apprisal forms for each employees i.e. around 2000 employees. Each employees spreadsheet has two tabs 1) Self Evalaution 2) Manager Evalaution. I need to get the data from the two tabs to a master file.

I am attaching the filled forms and a master sheet.

I need the follwing data to be extracted from the tabs

Self Evalaution Tab:-

Employee Name:
Employee No. :
Employee's Calculated Rating:
Employee's Self Rating:
Accomplishments:
Strengths:
Areas for Improvement:
Development Activities:
Comments:

B]Manager Evalaution Tab:-[/B]

Manager's Calculated Rating:
Manager's Rating of Employee:
Accomplishments:
Strengths:
Areas for Improvement:
Development Activities:
Comments:

Thanks & Regards

Violet