Macro to extract data based on dates

Hello,

Im a newbie to Excel couldnt find what I could accomplish
I have a sheet with 4 different coloums with Sheet containing Raw data
depending upon a condition in coloums B which is High,Med or low it should go to appropiate sheet and depending on conditions based in coloumn D and E which are Month Rages it should be able to pull data between those months by going to appropiate rows and paste them in data worksheet

Can someone please help me

Here is the link to excel file, any help would be much appreciated

http://www.speedyshare.com/files/23445170/Working_Proj.xlsx

Thanks