Can I update one worksheet from different worksheets?

[OM2]

I have one worksheet called ABC, say

I want to have 2 more worksheets: DEF and GHI
DEF and GHI are links to data from ABC - say for example they only show 2 selected columns for example

I want to be able to change data on DEF and GHI and have these be updated on ABC
Similarly vice versa: if data is updated on ABC, then this gets automatically updated on DEF or GHI

Is this possible?

If not... can I do this: have different views of ABC, view 1 would be columns A and B for example and view 2 would be columns C and D
The same applies: I want to change data once and have reflected on all worksheets

Thanks


OM

[OM2]

anyone?
kinda stuck here
thanks

[ROHAN999]

Kindly upload sample sheets ,so that anyone can help you in a better way

[Hurricanefly]

All you have to do is type an = in the cell on the def sheet, then select abc sheet press enter then go back to def sheet and drag down. This will copy the data from abc sheet on to def. You can then do the same for ghi sheet. Note you will only be able to change the data from abc sheet and it will update the other two. You will not be able to do this from def and update. I know that is not exactly what you want but it does the trick as long as you only update abc sheet.