Macro which will copy entire ROW to another sheet based on contents of one cell!

Hi All,

See the attached spreadsheet for exact details, but basically what I want is:

The employee will fill out their workload for each day on the "MAIN INPUT" sheet, then, based on what the cell says in COLUMN E, I want a macro linked to a button that will copy the different outcomes, to the sheet with the matching name which I have already created.

I also need them to appear on their sheets with no rows blank inbetween, with no duplicates, and in the same order as they appear on the "MAIN INPUT" Sheet.

I want the macro linked to a button that the employee can press to update the workbook.

I also want the employee to only be able to scroll from: Columns A - K, and rows 1-2000.

Can this be done? I hope so!

Any questions or if i'm not being clear, do let me know!

Thanks so much!

Chris

P.S. I have had a go at writing some code for the scrolling thing which I don't think works, may be best to just delete that and start over! Thanks!