Need macro to copy data from one sheet and paste to many sheets

I need help writing code that sorts a worksheet containing data for employees in the form of dates, and copies to multiple sheets based on the value in column "C". Employees work different units; each unit has one sheet for it's specific data.

Problem - I have been able to get the data copied accurately, but unable to paste if the row size on both sheets is inaccurate. In addition, I have created a row just under the data that contains statistical information, that I do not want to have "pasted over" when rows are inserted. Data is pasted from another database to the sheet "All Nursing Staff" when updated. I would like to be able to assign a macro to a command button to copy and paste the data to individual sheets for each unit when updated.

My Code:

Please Login or Register  to view this content.

So the entire row from All Nursing Staff should be copied to its respective sheet?

If you run the macro once and then want to enter fresh data into the All Nursing Staff page, will you clear the existing data and then enter the updated information or will you enter it in the next available row of that page?