add data to multiple cells multiple condition multiple criteria, retriev data edit view in

HI

I have holiday sheet it is kind of summary sheet I will use vba user form to enter data and view data.
When I open data entry mode the “Name “ sheet will appear blank and I will enter data that data will go to the “Hol-Pln” sheet and will add colleague name along with Data on the exact date and hours. but when I open in view mode the “Name” Sheet should retrieve data from “Hol-Pln” sheet according to the Colleague Name or employee number and also if I edit any data it will effect on the “Hol-Pln” sheet.

Please need urgent Help