Every Workbook feeds from one Master by =A2 etc into the first sheet
So the rows are just pulled down every so often to cover the data/rows in the Master.

One other Workbook gives a snapshot of certain cells in all the others.

At the moment I have to open each individually for them to update which is tedious.