need to create a summary sheet based on variable data

Hi All

I could really do with some advice!

Basically I have created a spreadsheet of information relating to different job sites around the UK. This list has about 50 entries (rows) and has approx 28 columns of information for each row. What I want is to create a summary sheet which auto-populates when you select the site number from a list. This summary acts as a printable sheet I can pass to an engineer which gives an up to date picture of what has happened at each site and when. Most of the data is text. I have attached an example to show what I mean.

Any help would be massively appreciated as I have spent all day trying to work it out by looking through forums and I am stumped!