Summary Sheet

Hi,

I want to create a summary or overview sheet for an events spreadsheet i have.

I want the user to be able to enter a job reference and the requirements will show.

Any ideas how best to do this?