Copying and pasting data from one excel worksheet to another or from the workspace to an existing worksheet

I have a macro enabled excel workbook with multiple sheets. Without creating a new workbook, how do I copy data from one existing workbook to another? Or from one sheet to another? Or from the workspace to an existing worksheet?

Answer 1

[jmac]

I find the spreadsheet link toolbox pretty handy https://www.mathworks.com/products/spreadsheet-link.html

Initialize the link, then use =MLGetMatrix() in Excel

[Sole]

Except I don't see the Spreadsheet Link for use with MATLAB and Excel check box on the Add-Ins. I'm using Excel 2016