I have an excel 'project' which has about 12 different sheets plus the "Main" one that contains personnel Leave days.

In one of my sheets, I have a button containing this macro:
Private Sub Annual_Click()
    With Selection.Interior
        .ColorIndex = 32
        .Pattern = xlSolid
    End With
End Sub
This macro will simply allow the user to select ANY cell and upon pressing this button it will change the interior of the cell/s to blue, thereby letting everyone know that those are that individual's leave period.

Right now I am doing the modifications to the leave days remaining manually on the "Main" page which in turns updates the rest of the sheets automatically, but what I really want is this:

Upon making the selection/s of cell/s and when they press the button containing that macro above, I would like the macro to update the individual LeaveTaken so that everything gets automated.

Example:
I have 20 days leave annualy and I will be taking 5 days leave only.

I select under my name "Salmerin" about 5 cells and I click on the Annual button, the 5 cells will change the interior color to blue on the active sheet and on the Main sheet it will search for "Salmerin" row and replace the number under the 'Leave Taken' cell with the 5 which the remainder will be displayed as 15 and so will the rest of the sheets after that.



Any ideas? Thanks