Maintain common data across two or more workbooks

[Manexcel]

I have two or more different workbooks / files that have common data which can change on a regular basis. For example names and addresses , contact details- email and phone, group numbers etc.

what is the best way to manage this common data across each workbook/ file so that i change the common data only once and other files get updated when opened The common data could also be sorted which also needs to be reflected in every workbook.

thank you for your consideration.

 

[codeliftsleep]

Create a seperate workbook that holds the data and have the other two workbooks get data from it.