Looking to pull data from one workbook to another custom formatted workbook

I’m looking to figure out how to pull data from one worksheet and drop it into a preformatted worksheet (same doc). Pivot Tables almost gets me there, but I think I may need to go a different direction given the specific layout.

I have 3 worksheets (from left to right) attached

1. Raw Data – all the referenced data
2. Print One Owner – the example shown is how I want the final product to look and is print friendly so you’re not constantly having to reset the Set Print Area or making several one-off worksheets. What’s not shown is a query/filter function.
3. All Detail Formatted – is similar to Item #2 above, but it shows all data grouped (and subgrouped) in a similar print friendly format.