Someone please help me.....Tanny

Could some one who has had this problem or would know what i could do....Lined up the other day with a 90 300zx twin turbo....I know sound's stupid....left the line...got the jump.....it was wet so all he did was spin....shifted from 1st to 2nd...fine still had him 2nd to 3rd...still had him Then 3rd to 4th....BOOM......and all i seen was the tail end of the little red devil...well i didn't like that to much so my question is....I need a new tranny ..the car is a 98 z-24 with the 5 speed...Where the hell can i get one?...And is it possible to put the Getrag trans and shifter in a 98......I will beat that Little red rice rocket!!!!