Power Query and Pivot Tables/Charts

[RodneyW]

I have a fairly good size document with numerous tabs. Data from each tab writes to a main tab from which I've set up pivot tables with charts that respond to selections I make via a Slicer. As the sheet has grown, the "response time' of data changing when I change my Slicer selection has increased, it can take three or four seconds which doesn't sound like a lot, but we're used to instant changes. Will it speed things up if I pull information for each of the separate tabs from another Workbook via Power Query or would it have no impact on the speed?

Thanks in advance