Slicer Connection lost - during copy sheets into new workbook

[slicer]

Dear All,
I am facing a issue during copying the below three different sheets into new workbook,
Option-1. Using Macro
a. Data sheet
b. Pivots - linked to the data source file
c. Dashboard - contains the charts & all slicers linked to each-other

Option-2. Simple copying & creating new workbook

but the result is same, final workbook contains the slicers but no connections options,
request you to please suggest a macro to copying the sheets with working solution.

Thanks in advance.

 

[Excel DJ]

I'm also having the same issue, strips all the pivottable connections. Love to hear if you've solved this!