And then it hit me. I could simply keep the same sheet I had, and change the title of the columns to match the sheet where I was trying to transfer the data. It was that easy the whole time. I felt so stupid for wasting all that time and energy! But I had to laugh it off. At least I learned new functions and cheats for Excel. I've just improved my skills. There is a silver lining!