Whoever suggested A Warrior's Call for the intro...thank you! That song and Tick Tick Boom by The Hives and Sick Sick Sick by Queens of the Stone Age are the truly elite pump up songs. Mentions to The Beautiful People by Marilyn Manson, Joker and the Thief by Wolfmother and Blue Orchid by The White Stripes. (Those are when it comes to none truly screamo/heavy metal material)
As for the goal song, I like the suggestion of Testify by Rage Against the Machine a lot. I also know that people won't agree with me, but I wouldn't mind the Feel So Close by Calvin Harris portion.