Vlookups

[BullseyeThor]

I have a question for all you smart people.

I have several Excel sheets that all do different things but they all use the same information as each other. The only thing is when I update any of the data that they all use I have to update all of them which can be long winded.

Is there a way that I can have one sheet with all the information and have the data sheets take the information from it and without it having to be open as well?

Thanks in advance

 

[Robert Mika]

I do not think is possible to write data to a close sheet.
From time to time you wil have to open them to refresh data o them