Making VBA run without clicking play

I have 4 worksheets that I want to aggregate into 1 worksheet. I inserted the following code into 2-A (the aggregated sheet). Sheets 1-A, 1-B, 1-C and 1-D feed directly into 2-A.

The code is as follows:

Please Login or Register  to view this content.

I want Sheet 2-A to automatically update when I change a value or add a value to 1-A, 1-B, 1-C or 1-D. I inserted the following code into each sheet:

Please Login or Register  to view this content.

The code works fine when updating 1-A, but not for 1-B, 1-C, or 1-D. I've atached the spreadsheet for reference. Any suggestion how to make the sheet automatically update in 2-A?

The Master sheet is 2-A.

2-A should be automatically updated whenever 1-A, 1-B, 1-C or 1-D are changed.

I hope this helps.