Hi guys

I have 2 tables in different workbooks that are related, which means if i update the table in the first workbook then the table in the other workbook should get updated automatically.How do i do it,is it possible?
If not then can i do the same but within a workbook(the 2 tables in 2 different spreadsheets) and how?

Anybody ,please
Thanks