VBA-AUTO FILTER slicers to display only 6 months in the month piv/tab slicer Multiple shts

Please help, new to this forum! I want autofilter pivot table and slicers to display 6 months only or it will get to big the data source. Please see the attached file below, on {"destination" and "desitination2") sheet tab where the slicers will be to display each sheet rolling 6 months in the slicers. If the dummy file is not opening up the file is attached to this thread.