Auto linking data without multiple vlookups

[Machalas]

Apologies if this has been posted before but I have been looking and can't seem to find the answer or if it is possible.


What I need to know if it's possible with one formula to autofill all of the various cells in the summary sheet (copy attached) with the corresponding information in the WLA sheet without having to put individual formulas in each cell in the summary sheet - i.e. to almost read across the headers in the summary sheet and find the corresponding cell in the WLA sheet. All the referencing will be within the same spreadsheet so hopefully this will make it much easier

Thanks

 

[Machalas]

Thanks for this - just what i was looking for