linking rows in excel

I am combining multiple excel spread sheets in on worksheet with multiple tab, Some of the columns are common across various tabs. Is there any way to link the columns across the tabs, such that if I enter data in one column, it automatically update associated columns