Staff Monitoring results that creates a new workbook of data with tabs per employee

Hi I really hope someone can help me,

I Need help re writing my Macro so each time the button is pressed it copies range B4:Q4 from the master workbook and pastes that data to each employee's personal workbook on a new line each time.. adjacent to the months in the table

i hope this makes sense and thanks in advance for your support!
Chris