I need to enter data only on one workbook and it should appear automatically
on other workbooks. It is possible for worksheets but can it work on multiple
workbooks as well or is there any other way to do this?

thankx!