Formula on how to extract datas to move to another sheet based on conditional statement

[isabel1217]

Hope you could help me, I wanted to transfer information from one sheet to another to answer the condition that I want. This is table one below on sheet 1.

Sheet 1

1 A B C D E F G H I J K L M N O P
2 Client No. 18/07/2015 19/07/2015 20/07/2015 21/07/2015 22/07/2015 23/07/2015 24/07/2015 25/07/2015 26/07/2015 27/07/2015 28/07/2015 29/07/2015 30/07/2015 31/07/2015 1/08/2015
3 111 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00
4 222 10:00 8:00 8:00 8:00 10:00 10:00 8:00 8:00 8:00 10:00 10:00 8:00 8:00 8:00 10:00
5 333 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00 6:00
6 444 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00
7 555 Dayoff 17:00 17:00 17:00 Dayoff Dayoff 17:00 17:00 17:00 Dayoff Dayoff 17:00 17:00 17:00 Dayoff
8 666 Dayoff 5:30 5:30 5:30 Dayoff Dayoff 5:30 5:30 5:30 Dayoff Dayoff 5:30 5:30 5:30 Dayoff
9 777 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00 6:00 10:00 10:00 10:00 6:00


Sheet 2

A3 - Client No. - 111
B3 - Starting Date - 20/07/15
C3 - Ending Date - 30/07/15

What is the formula extracting datas from Sheet 1 to Sheet 2 based from the information for Client 111 from starting date to Ending Date.

The result would be like this.

Client No. 111 Starting Date 20/07/15 - 30/07/15

20/07/2015 21/07/2015 22/07/2015 23/07/2015 24/07/2015 25/07/2015 26/07/2015 27/07/2015
8:00 8:00 8:00 8:00 8:00 8:00 8:00 8:00

 

[isabel1217]

Sorry for the table that I made..messy ...how can I post an excel picture here? I am using Mac. Thank you