For a particular event, we have registration information coming in via post, online registration and at registration counter.  Three separate excel workbooks are maintained for collecting data.  The three workbooks have a different series of unique numbers.

These 3 workbooks are consolidated into one MasterData workbook using Power Query-append feature..

So far, simple and good. Works as expected.

Now this masterdata needs to be accessed by different departments.  Separate workbooks with queries referencing MasterData query have been created and access given to those who need them.

Again, all good.

Now each department needs to add additional data for each record in pq table output -- additional data which is only relevant to them, and data which would be relevant to other departments as well.

How do I give them a place to update new information in their workbooks, which also ultimately updates the MasterData workbook and gets shared with others using different aspects of this MasterData.

Even if this addnl data were not to get shared with others or with central MasterData, they still need a place to add additional columns to the power query output table, so that base data continues to get refreshed from Master and additional information added for each row, stays alongside that particular record only.  I tried adding additional columns but the data does not reference the same record every time the query is refreshed (and I can understand why).

What is the solution to this?  I am very new to PQ.  I might have missed something very apparent and common.  Help will be sincerely appreciated.

Nz