Auto populate adjoining cells

Hi all,

I am familiar with Excel as a basic user but I have now been tasked with doing a score system for a local club. I have put together a spreadsheet with two separate worksheets, one that the person hosting an event will enter scores and the other holding members details. What I want to accomplish is that when the hosting club takes an entry on the day, they can start to type in a surname or membership ID number in the relevant columns and Excel will look up from the members details worksheet. This will then populate the corresponding columns so that all that needs to be done by the event holder is enter the scores.

I have attached the spreadsheet to show what I mean and any help would be hugely appreciated,

Yours in hoping,

Bob.