Extract info from a large dynamic excel sheet.

[indesh]

I have an issue, i usually work with 3d and i export all my working in excel to summarise in a table.Now i came across an issue whereby i have a whole exported list for the whole project and i want to extract some of the info to make a new table.My master list is a dynamic one it keeps on updating from the project.

I have attached the sheet, there is one master sheet and 2 other sheets, PID10 & PID2...those sheets are break down table form the master sheet.

Can anyone help me please....its been 3 days am stuck on this...