Pivot Table Data Source/Field Settings

I have ~20 pivot tables in a workbook (let's say workbook A) that I am creating a copy of in workbook B along with the source sheet. But the data source remains the sheet from workbook A. I can manually change the data source to workbook B but the problem arises with the fields.

The pivot tables have row entries 0-150 and (blank) but some of these rows don't have data. They can have data in the future but don't as of now. When I change the data source the blank ones disappear. How do i stop it from happening? I need them all because the cells have dependents. I can't change it to refer to the pivot table dynamically, the file wasn't made by me and there are far too many to change.

So the question is, is there a better way to copy the pivot table over to workbook B from A or is there a way to change the source and retain all rows?

(Using Excel 2016 if it matters)

one way
workbook 0 = source
workbook A - get data from workbook 0 via PowerQuery (as connection) and create as many PTs as you want
workbook B - get ..... as in workbook A

you can use workbook A as source of course without workbook 0

I have code that modifies source, I don't want 2 files open. The whole point of copying data from A to B was to consolidate 4 A's (with several PTs each) into one file.

I did some mucking around and here is the latest update:
Point PT in workbook B to source in workbook A: contains all 150 rows.
Make exact copy of source from A to B and point PT in workbook B to that: doesn't contain 150 rows. This completely stumps me. I have no clue.
Recreate PT in workbook A using workbook A as source: Doesn't contain all 150 rows.

with PQ you don't need open all files (PQ works with files closed)
from B get source A via Power Query then create on B Pivots