Get data from one sheet to other based on one cell status in excel

I have sheet with data, i want to get data in other sheet but with conditions.For ex:

-------------------------------------------------
| Cell A   | Cell B |  Cell C    | Cell D|Cell E |        
|------------------------------------------------|
| Sku      |Order_ID|Customer_ID | Price |Status | 
|------------------------------------------------|
| TW22     |   123  |    1       |221    |   D   |
|------------------------------------------------|
| TS44     |  124   |     2      |221    |   D   |
|------------------------------------------------|
| Ts11-ab  |   33   |     3      |211    |   D   |
|------------------------------------------------|
| Ts11     |   231  |     4      |231    |   D   |
|------------------------------------------------|
| Ts11-ab  |   33   |     3      |211    |   R   |
|------------------------------------------------|
| Ts11     |   231  |     4      |231    |   R   |
|------------------------------------------------|

This is sheet 1 data as above show. When i got order new row add in sheet with all details like Sku,Order_ID,Customer_ID ,Price ,Status ( D means delivered and R means return) .If Customer order product and we delivered it but if Customer return the product in sheet 1 new row added with return details .
I have data in sheet as above in ex:, Now i want values like bellow in my other sheet ex:

Now this is my sheet 2 given below. i want to get values from sheet 1 in my sheet 2 , as in sheet one i have lot of data . so i want to refine it in sheet 2. in sheet 1 if order status return formula must skip D values for same order id and get values for R . as i try to explain in my 2nd example below. in Sheet 1 order id 33 have two rows , With "D" and with "R" . now in 2nd sheet i want to formula skip order id 33 's data with value "D" entire row . and only show data with value "R" in sheet2 . if order id have only D value then it will provide "D" values data in sheet two like i explain in example as order id 123 have only record with "D" so in sheet 2 it will provide data same as in sheet 1. so main motive is if Cell E have "D" and "R" for same order id so i need "R" values in sheet 2.

-------------------------------------------------
    | Cell A   | Cell B |  Cell C    | Cell D|Cell E |        
    |------------------------------------------------|
    | Sku      |Order_ID|Customer_ID | Price |Status | 
    |------------------------------------------------|
    | TW22     |   123  |    1       |221    |   D   |
    |------------------------------------------------|
    | TS44     |  124   |     2      |221    |   D   |
    |------------------------------------------------|
    | Ts11-ab  |   33   |     3      |211    |   R   | 
    |------------------------------------------------|
    | Ts11     |   231  |     4      |231    |   R   |
    |------------------------------------------------|

attached file http://www.excelforum.com/attachment...1&d=1475134694