I have found success using Google sheets first. Copy from book 1 to Sheets, then from sheets to book 2. My new organization doesn't allow for sheets which is why I'm here looking for a new solution.