Pulling all info on worksheets by sheet name drop down

Hi all!

first time posting so I’m excited to see what can happen! 

I’m looking to speed up a process within my work place by creating a ‘summary page’ which puts all the data we’d need to see on one worksheet.

So, say I have 5 sheets in one workbook, titled ‘summary’, ‘table 1’, ‘table 2’, ‘table 3’ & ‘table 4’. 
On my summary page, I’d like to put ‘table 2’ in a cell then see all the information in the sheet ‘table 2’ populate on my summary page. And if I change that cell to say ‘table 4’, all the content within the ‘table 4’ tab would populate instead.

does this make sense to anyone? If it’s possible to do as a formula I’d really appreciate some help writing one. I am open to VBA, however my knowledge of it is that of a 10 year old. 

thanks in advance!