Macro to extract and list data on a new sheet

Can someone please give me some help with this problem?

I have 2 work books, one called ( Warehouse Wastage ) which is the master sheet

The other is called ( short coded ambient allocations 160712 )

If you open the master sheet you will see I have some hyperlinks under peoples names, these hyperlinks are pointing to the ( coded ambient allocations 160712 0 sheet

When the link is clicked it brings up the sheet, but what I am looking for is when a hyperlink is clicked instead of bringing up the whole sheet I want it to only list the products against the name.

If you look at G7 on the Warehouse Wastage, you will see a sum of £50.40 under the name Jimmy, when I click on this sum I would a sheet to appear with only Jimmys products, in this case it will list ( coded ambient allocations 160712 ) A21 – U21

On the coded ambient allocations 160712 sheet the names are listed in the U Column

If I click on the sum under Ross on the Warehouse Wastage sheet I would like it to list all Ross’s product from A – U

Is this possible?