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 se...