Autofill column outside of pivot table

I need to use the data in a pivot table to do additional calculations. The pivot table grows in rows every day. I have a table to the right of the pivot with references to pivot cells but they dont autofill down when the pivot refreshes. Is there a simple way to do this without having to paste a formula through the entire column referencing blank cells.

Here's what i have. I am combining session data for blog articles in a pivot table and then index/matching for more information about the article.

Using that master table I want to build pivot tables to get daily rolled-up reporting.

Right now to do this I have a macro that copies the Analytics pivot and pastes values then fills in the table.

Really just looking for the most efficient way to do this. Open to changing anything.

Had ya then i lost ya