Sync cells from workbook A to workbook B, where the B users don't have access to A

I'm trying to accomplish the following, and am unable to find a workable solution here or on Google. Have to admit I find it hard to construct the right search query.

The scenario: I have a workbook ('A'), which I use on a daily basis. It's located on a network drive. There's a second workbook ('B'), also on a (different) network drive, I have certain cells synced from A to B. B is used by other employees. The issue is: I can see the sycned cells in B just fine, but the other employees can't, because they don't have read access to the drive on which A resides (and it can't be given either, the rest of A is confidential).

Is there a way in which I can sync cells from A to B, without B requiring access to A? So no dynamic bidirectional link, just write ('push') values into B.

Hopefully this makes sense, if not, please ask for clarification.

Thanks in advance!

try Power Query from B to A with accessible data, users can Refresh data on B if something changed on A