Automatically transferring data from one row to another

Thanks! This works perfectly except the data does not paste in Row 28 (the first unused row). Instead, it pastes a few rows after Row 28. Any idea why that is?