Macro is grabbing from Pivot table wrong

So I have this macro that works wonders! No More pasting and coping every week! The problem is When it gets down to Hospitality Aide, where the first payroll is 3/11/19 it pastes it in the first row of the report which is 1/1/18. How can I fix this? This is the part of the macro that pulls from the pivot table.

Please Login or Register  to view this content.

Instead of pasting row 1 I need it to paste via what the headers say.

THAT WORKED GREAT THANK YOU!!! such a relief. But not I have one other problem. Now My pivot table under the 2019 year has 1/2/18-12/31/18 Payroll in it but there is nothing there because the data is all in the 2018 year. but it's bringing that over to my report. Which is making the Grand total off. So I have a 2018 Total (at the end of 2018 payrolls), 2019 total (at the end of 2019 payrolls) and I have a Grand Total right after 2019 totals. In Hospitatily aides it puts the grand total in the Second 1/2/18 payroll?

it seems the problem is when I select show items with no data, when you subtotal by year it puts 1/2/18-7/15/19 in the 2018 year and 1/2/18-7/15/19 in the 2019 year. With Hospitality aide there is only payroll in the 2019 year so when it does the splicer it only shows 2019 year. Therefore it actually puts it in the first 1/2/18-7/15/19 range which is why its throwing it off. When I choose to show items with no data for the year it puts everything in the right column BUT it has the 2019 in 2018 and 2018 in 2019. If there was a way to hide the duplicates with no data this would work. Is that possible? for 2018 to only show 2018 and 2019 to only show 2019. Or Auto hide those after its done? Which I add a new payroll every two weeks so the hiding columns would change. OR I could just go back and Manually hid in the report after all is done. That would probably be the simplest.