Adding two cells in different worksheets using VBA

Hi all,

All I want to do is to add two cells in different worksheets using VBA. I want this to be part of another macro hence why i don't want to use a formula in excel. So what I want to do is for the value of sheet2 b4 to be the sum of the value in sheet 1 b5 and sheet2 b4. therefore when i run the macro, the value in sheet2 b4 will always be updated with its value plus whatever value was entered into sheet1 b5.

Please help.

In addition to the above, how would i run this down a row of data (b8:b22) and across to the next column (c8:c22)

Thank you