Datasheet with drop down
 

I am working in Excel 2007 and I was wondering if it is possible to put a
datasheet on sheet 1 to pull a part of the data I have entered on sheet 2
based on a pull down box.

Sheet 1 is a Dashboard
Sheet 2 is the Data Coumns A thru AF, Rows 4 thru 350

I want to insert a Combo Box in sheet 1 where I can choose Listings,
Pendings, Closed and a datasheet would populate with data from data sheet 2
from columns A, B, D, E, and G . The datasheet would have to be able to
change size according to the number of rows to populate. I was also wondering
if it is possible to have 2 criteria to populate the datasheet, 1 would be
for the Listings, Pendings, and Closed and the other would choose a month
Jan, Feb, Mar, etc. based on a date in column N for listings, column Q for
Pending and column S for Closed.
Thanks