Automatically update or copy data from one workbook to another

[Flergleburr]

I have 2 workbooks. A lot of information is the same and manually entered by the same person into both workbooks. I want the person to only enter the information into one workbook and populate the second automatically.

The only way I know how to automatically update it would mean that when shared the external person would get #REF errors or similar as they don't have access to the source data/other workbook.

These workbooks are updated multiple times a day, by multiple people. I don't want to introduce a manual step into the process (such as remembering to save the workbook with the data not the formula before sharing it).

How do I tell workbook 2 to take the information from columns A, B and D (for example), but still be accessible by the external party?

 

[EFANYoutube]

So a couple of questions:
Does the person updating the workbook always have the other one open at the same time?
Is there ever a time when 2 people are updating the workbook at the same time?
Is there ever a time that the second workbook is being used by someone else when someone is trying to update it?

With these answers I think I can help

 

[Flergleburr]

Does the person updating the workbook always have the other one open at the same time?
Is there ever a time when 2 people are updating the workbook at the same time?
Is there ever a time that the second workbook is being used by someone else when someone is trying to update it?

Oh you won't like these answers!
1. Sometimes
2. Yes
3. Yes

Both workbooks are on 365, so the ability for two people to have the same workbook open is used, and it's helpful to keep that ability.

 

[EFANYoutube]

Ok, so a couple of more questions
What data exactly is being updated? e.g. is it a static sized table, or individual cells?
How are you with VBA?

I think I could make a function but would have to work out how you need it implemented