Auto updating table from another worksheet

I am not sure if this request requires VBA programming or not. Basically, I am trying to automate a copy and paste function.

I have a cell data range from A114 to I152/153 (merged cell) in a worksheet titled CONTRACT. My goal is to have whatever is showing on worksheet CONTRACT to also be applied to worksheet titled INVOICE #1. Meaning, if I were to delete entire rows or add entire rows to worksheet CONTRACT, that the resulting table within CONTACT is identical to what is shown on INVOICE #1. But I want to do this without have to RE-copy and paste once a change is made within CONTRACT.

Able to be done with VBA? If not, how can it be done with VBA?


My usage of VBA programming is very very minimal = noob.


Thanks in advance!