When you get a pawn to the end of the board can you make it any piece you want?

No. The player has the choice to pick whatever piece they want. As the queen is the most powerful piece, they usually pick that, but they don't have to. So a pawn doesn't automatically change into a queen on reaching the end of the board.