how to pull multiple dates from another workbook

[webber15]

		friday		monday
part	qty	date	qty	date
140880	25	6/20/2015	50	6/30/2015
140890	25	6/25/2015		7/15/2015
140891	30	7/20/2015	100	10/15/2015

<tbody>
</tbody>

i have a report ran everyday for shipment dates i want to know if it is possible to pull in multiple dates when i pull the report on Friday.
ex. On Friday for part 140890 there is a shipment for 6/25 but on Monday, the shipment was canceled and the next recent is not till 7/20. i want to be able to pull both the 6/25 date and the 7/15 date in on friday so i know what the next shipment is

 

[webber15]

any idea on how to achieve this or any alternate solutions would be helpful also