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.

[TABLE="width: 725"]
<tbody>[TR]
[TD][TABLE="width: 725"]
<tbody>[TR]
[TD]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:

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]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.[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]