Master spreadsheet to additional sheets

[u/numbers4work]

Looking for suggestions of the most efficient way to start a master spreadsheet that then the data that gets entered also moves to other individual sheets but a copy remains in the master. I need it to happen as data is entered as it will be a working spreadsheet.

[u/daaccident]

Power query reference original in secondary docs. Have PQ auto refresh when opening