I have 20 employees that have the same exact statistics (that take up about
50 rows of data and 15 columns each). I want to be able to pull a particular
employee's data over to a summary tab.

I want it to work as follows: Be able to enter the employee's name in cell
A1 on the summary tab and have that employee's data populate on the 50 rows
below and 15 columns to the right. I could use an "if then" if there were
only 8 employees, but what do I do since their are 20?

Do I name ranges and use some special formula or what?

Average excel user here so please be detailed in how to accomplish this.

Appreciate it!

-Steve