EXCEL function problems

In total there are 201 classes in sheet1 Xiaoming birthday results.202 class birthday Xiao Zhang accomplishments.
When I re-enter sheet1 in 201 classes of information, the information can be directly transferred to sheet2 table.By the same token, when I enter 202 students information, the information can be directly transferred to sheet3 table.(In the summary sheet in the name of the class)

click to enter SHEET1 in 201 of the grid, type =, and then click should SHEET2 intend to enter the grid, according to the enter key on the line, it is necessary to repeat this action, they SHEET1 mouse on the 201 in the lower right corner of the grid will be Cross has, according to pull down, how many want to lose on the line and Latin America the number of lines, insert the line – the name – the definition of the current work in the name of the table:The table name; cited location:= RIGHT (CELL ( “filename”) , LEN (CELL ( “filename”))-FIND (“]”, CELL ( “filename”))), to determine.(When used to copy ctrl + V)
assumed sheet1 “total”, at the table Worksheet name should be the class name, such as:201 (and you should be in the general table of the same class with a total of 201 classes is a table, here is the 201 class).Assumed that there were 10 lines of data.
Points in the table A1 Input:= INDEX (summary! A:A, SMALL (IF (summary! $ A $ 1:$ A $ 10 = current table name, ROW (summary! $ A $ 1:$ A $ 10), 65536), ROW ( )))&””
By shift + ctrl + enter to determine.A1 and then down, filling the right, that is, driving.

============= ============
by the name of your class 201 classes sheet2 your name will be changed to ban 201; 201 by the name of your class, your name will be changed sheet2 Into 201; ……
sheet1 to be renamed:summary