text area in MS Excel 2000 VBA

I have this worksheet whose first sheet is the “input” sheet while all the other sheets are protected sheets whose input comes from the first sheet. Now i have been trying to find a solution to having a test area which will take the input and paste it into the output sheets. The problem that occurs is the formatting. I want them to fit in the print area and be word wrapped. Does anybiody has an idea as to how to accomplish this?