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