Duplicate Table/Columns on another Tab

Hi Everyone,

Is it possible within Excel to take a table of data and duplicate it on another tab. This way whenever a name is added, or deleted, it would automatically make the same adjustment on the other tab? For example, I have a tab called MASTER, which list names and contract information on A4:C115. I would like to create another tab called closeout and duplicate these exact names and information in each cell. If I delete a name in master, it should automatically take effect in the closeout tab. If i add a line, it would do the same.

Is this possible?

Thanks for the help.

Hi PCI,

Do you mean have a macro just copy the entire range upon change and paste it into the closeout? We make changes in here quite a bit, do you think that would slow the spreadsheet down? Or make it buggy?