Import external data

Hi there. I was searching allot around web about how to solve my problem but i have no luck so as last hope i write for help here.
I am programmer 13y and i am new in automation in Excel. I know VB too.
Is it possible to do this in Excel :
I have one workbook with table containing columns a,b,c and rows 1,2,3.
I will try to visualize the table next for ease understanding:
....a b c
1 A B C
2 D E F
3 G H I
So now i have another workbook where i need to make the values to enter in the rows automatically like this: if i write A in the first column first row then excel to enter the values B and C for the first row second and third column.
Is this possible and if anyone know how or where i can find some info about this i would appreciate the help.
Thanks in advance.
Best wishes to everybody.
Sincerely Svarc.