VLOOKUP to different tabs..

Good morning all,

This is my very first post and probably not the last

I have a bit of a problem which I hope someone will be able to assist me with?

Basically I have data in 4-5 different tabs which need to pulled through based on a criteria on a front "summary page"

Example is attached.
Any help would be appreciated.

Thanks,