The text my functions return doesn't spill over to adjacent cells on the new worksheet.

Hello everyone! I'm a bit new to excel, but despite that i've tried my hands at what i consider a "difficult" challange.    I'd like to have two sheets, one that contains all the information, and a...