vlookup multiple sheets

[exceliz]

Hello

i have a spreadsheet with about 20 tabs made up of specialties.
i want to collate information into one collated sheet by looking up the information on each speciality sheet so that on the collated sheet they can select a specialty and all the infromation is populated.

the information consists of targets
e.g.
elective LOS
emergency LOS
for each speciality.

thanks any help appreciated