Hello...I have hundreds of excel records, all from 1 template I made, so columns are all the same, and I would like to grab 1 specific row from each record and put onto new sheet, for the pupose of being able to sort, etc. The records are baseball stats procduced from a game I play, so any similarity to MLB ends at the name of the players, stats are not actual...So, here is what I have in a shortened version:

Columns: Name Year Team Ave AB's Runs Hits Etc
Totals XX XX XX XX XX XX XX XX
XX XX XX XX XX XX XX
XX XX XX XX XX XX XX

Ok, now imagine I have hundreds of these sheets, the Totals row, Line 2, on the sheets, is the row I want to grab from each player. (I have the sheets so that the numbers add upward to the totals). Basically when finished I want to get rid of the Year and Team column as these are not needed. So the finished project should read as follows:

Columns Name Ave AB's Runs Hits Etc
Totals AA XX XX XX XX XX
BB XX XX XX XX XX
CC XX XX XX XX XX

Ok, how do I go about accomplishing this, or do I just have false hopes? I am not a programmer, but was thinking writinig a macro would help, but not sure. Any pointers or solutions would be greatly appreciated.

Thanks