Populate Table from other sheets based on drop down selection

Hey all,

So i have this excel sheet, with a summary page on front. The summary page has a drop down menu to select the month desired. What i want is for the summary table to populate with the desired data based on the month. i thought about using a VLOOKUP, even tried it, but that doesn't seem to have worked.

here is the file. right now im just worried about getting the first table to work. Currently it fields are blank, its the formula i need to work out. Any help would be greatly appreciated


i tried to use ( =VLOOKUP($A$2,Sheet2!$A$2:$O$36,5,) ) as the formula but that returned errors.