Copy a table from SAP and insert it into active excel sheet

Hello Guys,

I created a macro which runs a SAP transaction. The outcome of the transaction is a SAP screen which shows a table. I would like to copy that table and paste it into my active excel sheet. In total I will need the following steps:

1. Run report
2. Select the table/ needed cells in SAP
3. Copy Selection
4. Paste selection

I already did step 1 and 2 and they work. Unfortunately, I don't know the command to copy my SAP selection (3).

My Code:
'call transaction
session.findById("wnd[0]").maximize
session.findById("wnd[0]/tbar[0]/okcd").Text = "/n/SIE/E_P_ORDER1"
session.findById("wnd[0]").sendVKey 0

'entries for dates etc..
.
.

'select data
session.findById("wnd[0]/usr/cntlGRID1/shellcont/shell/shellcont[1]/shell").SelectAll

'copy data (I need help here!)

'paste data
Cells(2,2) = ....

I appreciate any Help!
Thank you,
David