Hi please I need help. I want to use an excel file named for ex:Contracts as my workbook this file contains this cells: model, interval, KmC.
And other excel files as source of data, here is what I want to achieve in

steps:

1- In Contracts when I write model name in B1 the system should choose the file with the same name. nothing will happened just picking the right workbook for the rest.

2- when I write kmc B2 it should be updated in a given cell in the right workbook that has same Model name.

3 - same think as step 2

NB: after updating these values the amount and tax will change in the model file that we are working with.

4 - now I want to retrieve the amount and tax in the workbook that has the same name of the model that we write in the first step.



Please I need guide for what I have to use in each step or what I should learn in the future to do those kind of things: exchange data between file, Data manipulation. Create word documents from excel.

Thanks in advance