I am wanting a drop down on one sheet to bring the full data from one of 3 possible sheets depending on which drop down is selected

I am currently designing new audit template reports. I have decided to have 3 contracts on one spreadsheet (3 separate sheets) but only have one Summary sheet. My idea is to have nothing but a drop down list on the summary page and choose which Summary I want to drag through for which audit I am completing.

So I would have: 1x Summary sheet - blank with just a drop down 3x Audit templates 3x hidden Summary sheets which would automatically calculate there own data from each of there audit templates.

The Summary sheet on show would then pull the entire data from which every hidden summary it needed to depending on which drop down I select.

I am positive there is a way to do this using a VLOOKUP, IF and Drop down but I cannot for the life of me figure out how to do it. Any advise would be much appreciative.

PS I have googled this and looked on forums but people just seem to be putting certain info on the page and not the full data, formulas etc I would need.

Thank you