help with summarising a table

Thanks Wyn, I looked at Pivot Table option. The set up is part of a bigger one where I want people to be able to select themselves on the first page and then it look up the transactions on one tab and then do similar look ups for their assets off another tab and there team members off a third tab.

When I looked at pivot tables, it says that you can't use a formula or a reference to select the person, so they would have top select themselves for each of the different tables. So I was wondering if there is an alternate method.