I have an Excel file with one "Master" tab and 6 "client" tabs. I have a code that copies the last row of the active worksheet into Master tab, but only certain cells from the row.

Now once the cells are copied into Master I would like to be able to keep it updated, so if I make a change into one of the cells (in any client tab) copied from Client to Master then the change is reflected into the "Master".

Is this possible?

I have a code that track all the changes made in Master with date, old data, new data, who made the change, time and link to the cell so that's a safe. but so far I can only do manual changes.

Any advice would be greatly appreciated.

Thank you,