Use visible rows from autofilter to build Pivot table. Or use visible rows to Copy/Paste

Good morning!

Help!! I'm on a time crunch and i cannot figure this out.
I have looked relentlessly and i cannot figure out how to do this.

I have a workbook which is attached.

I have created a macro that when ran, will autofilter the data in the 'Raw' sheet. Column H will only show 'N' and Column O will only show the date that is 5 business days PRIOR to the date located in C2 on the 'Tables' Sheet.

This filter function works.

But i need to automatically create a pivot table using ONLY the visible data derrived on the 'Raw' sheet. I would like to put this function in the same sub as the autofilter macro.

This table needs to be on the tables page.

I'm not sure how to do this.

Would I need to copy and paste the visisble data to a worksheet first? Then have the macro create the pivot table from that worksheet?

Hope this makes sense!

Thanks in advanced!