Vba code/form to transfer data between excel files

Modify/Optimize existing VBA code to transfer data between files, user will enter row number for destination file. Review existing code and optimize/change as needed. Current code only transfer one row, implement loop function and get row number for destination from userform data.