Developing a reusable/simple team chart

[dweagle]

I am a football coach. I keep a chart of defensive stats for our team. I've tried to set this thing up so that it will be reusable year after year and be accurate with limited changing of formula. I've set up filters to change the player's names and numbers automatically from the first page and all their stats on the first worksheet transfer to the proper row. The problem is that on the other game worksheets, the stats do not move, just the jersey and name. I have tried all the ways outside of macro, which I've come to find out is what I'm limited to on Excel, that I can think of. I think I have to use a macro but I don't even understand what I'm typing in and how it effects the worksheet. I've tried editing and rewriting this [http://youtu.be/SV_VJ4qmRjk] macro, located in the info about the video, but it was no luck. Can someone help me make a code that will filter each page, ideally with just hitting the enter key like the before mentioned video and protects the workbook from someone accidentally deleting or changing a formula? I only need a this macro to effect games 1-10 and the make up game, all tally sheets should correct automatically. Any help at all would be greatly appreciated. Also, if you see something in the chart that can be corrected or made more simple, feel free to elaborate.

Thanks