Link data between sheets

I have 4 sheets

When I add the contract number in Sub1, the data will appear the other columns in Sub 1, Sub2, Sub3

Besides, when I change the data any columns in Sub1, Sub2, Sub3, "Total" will be updated the changed data

I think that the problems can be solved by VBA but I dont know that.

Thanks for any help