Transfer bespoke data to different workbooks

[john1000]

Hi everyone, I could do with some help. I'm working on a project where I need to take selected data from worksheet 1 and then break it down into different sub categories in worksheet 2.

The above is worksheet 1. I need to take the higlighted info from this worksheet and consolidate each tab into a new workbook (image below) where I will then split the information down even further. Where you see the policy numbers (fake for the sake of this example) I need to separate the AB, CD and EF numbers into their own categories so that they can produce their own totals. Workbook 2 needs to look like this: So that's just me manually copying and pasting that data and leaving out the bits I don't need and filling in the bits I do need, but that is basically how it needs to look. What formula could I use in order to apply that kind of rule to the workbook? Is it then possible that when someone updates workbook 1, workbook 2 will automatically update everything without manual intervention from me? Cheers everyone, if I need to make any points more clear please ask. I really appreciate the help. <tbody> </tbody>

<tbody>
</tbody>