Copy and Paste rows to multiple worksheets based on a cell value.

And are you doing this regularly or as a one-off? Will the data in your first sheet be added to or replaced? Should data in the other sheets be overwritten or added to? The code to transfer to sheets is straightforward, but would help if you could clarify these details.

This sheet is used as a template on a monthly basis. So each month we just change the name of the first tab. So each month we start with a blank sheet and add in the information from a seperate sheet from another department.