Returning a data list from one sheet to another based on a drop down menu

[kk59204]

I have a worksheet where agents enter travel expenses. This sheet is updated daily and I need to be able to pull monthly reports off of this (I would like to build more flexibility for weekly reports or agent specific reports but I want to start with monthly reports). I would like the data to be pulled from one table to fill in another table. I attached an example?