Work and Combine data from 2 or more excel workbook....how to do it?

[besmart]

hello everybody,

i'm new here , so please don't be mad if i post in the wrong place...

i need a little help , for one of my work....

so i use 3 tables for my work, and every day i'm introduce new datas.
In all this tables , i have common colums, and i want to do somehow, i don't know how....that when i insert a data in the 1st table , automaticly some of this data to be written in the last 2 tables(of course in the common colum)...

thank's , and sorry for my english!