How to make a summary sheet?

Hi,
As im not sure what I need for this I have posted in the general section so I apologise if this is the wrong place.
Ive been a basic user of excel for a long time now but im now needing to use its more advanced capabilities more and more and would like some help with my problem below, I would just like to know the types of formula or tables I will need so I can find out how to do them.

I have created a spreadsheet which is for me to keep track of numerous tests done on a product.
columns include;
The test name (around 10-20 different ones),
Short description of test
Software version
Hardware Version
Date test was completed
A link to the results or a short description of the result
Conditional formating to say completed/need to/in progress etc.

The problem is it tends to fill out quickley as the same test can be carried out on multiple different versions leading to a large table, I have allready added filters to the columns so I can drill down to find a specific but ideally I want to create a summary sheet.
This would show every different test on the latest version it was done (i.e. copy rows for the latest version (date) of every type of test completed)

Can anyone help me - or is this even possible xD?
Thanks

Thanks for the reply, I have allready had a quick look at pivot tables but it didnt seem capable of doing what I want it to do. HoweverIi will have another look anyway. Also someone mentioned to me about Slicers in Excel 2010+ is this option better?
Thanks