Can you please explain what exactly you want to copy (exact range) and where to paste?

How do you want to chose destination workbook/worksheet?