Returning data across multiple sheets based on drop down list selection

Hi,

I was wondering if I could get some help on the best way to retrieve data from my drop down list selection and return the corresponding data from the corresponding named sheet without using macros.

In the attached spreadsheet I have a drop down list in A2 on the summary page. Whichever month I select I would like the data from that month's worksheet to populate the summary page.

I tried titling each month of data in the name box to use data validation, and also some different lookup and match formulas but i'm unable to make it work properly.

Thanks

Rooboyz

Its difficult with your table lay out, because you have so many merged cells, its painful for formula to return the results.... for the first step, remove the merged cells and just resize it if you need bigger or wider cells

Thanks

Thanks guys that's fantastic! Appreciate the help!